I am guessing the analyze helped the pgadmin data-dictionary query planning..The vacuum will help with space re-use. the size is not smaller as I did not do a vacuum full. On Mon, Oct 26, 2009 at 4:27 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > 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
