Agreed... Thank you On Mon, Oct 26, 2009 at 3:46 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Anj Adu <fotographs@xxxxxxxxx> writes: >> We have several partitioned tables that get dropped every day ..We do >> not do autovacuum as it is an IO hog (and most tables are dropped >> anyways..and the large tables are never updated).. > > If you're not going to run autovacuum then that means *you* must take > responsibility for vacuuming everything on a reasonable schedule. > That includes the system catalogs. I think you'd be better off taking > the effort to learn to tune autovacuum to fit your requirements. > > regards, tom lane > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin