On Mon, Oct 26, 2009 at 3:29 PM, Anj Adu <fotographs(at)gmail(dot)com> wrote:
> 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)..
1: autovac can be adjusted to use much less IO than regular vacuum.
2: You can tell it to ignore certain tables.
> I however did a plain vacuum analyze and that fixed the problem with
> tools(e.g pgadmin) that accessed the data dictionary and were very
> slow before the vacuum.
Huh. Is the pg_attribute size much smaller?