On Mon, Oct 26, 2009 at 3:29 PM, Anj Adu <fotographs@xxxxxxxxx> 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? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
