salman salmanb at quietcaresystems.com
Thu May 22 09:25:20 PDT 2008

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


More information about the Slony1-general mailing list