Laszlo Fogas <[email protected]> wrote: > Sorry, I wasn't clear. > > Autovacuum runs with default setting, I believe it's daily, or > whenever it feels like. > > When autovacuum was disabled, we had this problem once every 2 > months. > > With autovacuum enabled, we had this problem once in every six > month. That was quite clear. > It seems autovacuum could only delay the event, but not prevent > it. Autovacuum with default settings improves it drastically. Autovacuum with more aggressive settings might well prevent the problem entirely. -Kevin
- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
