On Wed, Apr 29, 2009 at 4:00 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Wed, Apr 29, 2009 at 9:59 AM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > >> At this point you may be better off just doing a backup and restore and >> then figure out why your maintenance routines are failing. > > OP said he was running 8.1. I think autovacuum was turned on by > default on 8.1, so first step after dump restore is to turn on > autovacuum. 'was turned OFF by default in 8.1' -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin