Re: pg_attribute size

On Mon, Oct 26, 2009 at 3:29 PM, Anj Adu <fotographs@gmail.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?