Thu May 22 09:25:20 PDT 2008
- Previous message: [Slony1-general] Slony Vacuuming DB
- Next message: [Slony1-general] Slony Vacuuming DB
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Christopher Browne wrote: > "Rafael Domiciano" <rafael.domiciano at gmail.com> writes: >> Frequently Slony is vacuuming my database, and I'm having to kill his proccess because it's slowing the client-side application. >> I tryied to find option that disables the vacuum but i'm unsucessful. >> Someone know how to stop vacuum's Slony? > Not sure what kind of a shop you run and how many inserts/updates/deletes you do during a day -- we do about 5.5M inserts a day, and we archive ~3-4M records a day (dumped to disk, removed from production db) and the slony vacuum jobs do not slow anything down for us. The only time we have slowdown is when one particular script leaves an 'idle in transaction' query open for a number of hours -- once that happens, slony's fetch requests and the growing log table really drag the server down. But, the problem isn't created by slony here, obviously, it's one of our scripts. -salman
- Previous message: [Slony1-general] Slony Vacuuming DB
- Next message: [Slony1-general] Slony Vacuuming DB
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list