Christopher Browne wrote:
"Rafael Domiciano" <[EMAIL PROTECTED]> 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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
