Laszlo Fogas <laszlo@xxxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
