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).. 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. On Sun, Oct 25, 2009 at 9:41 PM, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote: > Anj Adu wrote: >> >> I have a few databases where the size of pg_attribute > 6G.. This >> keeps growing.. >> >> is there a recommended way to purge data from this table.. Could this >> also be why tools like pgAdmin take forever to open the database >> browser? >> >> > > Do you have an extraordinary number of tables/columns? > > Try (as the database administrator), "vacuum full pg_attribute" perhaps > followed by "reindex table pg_attribute". Be aware that this may pretty much > lock your database while it is running. See if things improve then do as Tom > says - make sure autovacuum is running. > > Cheers, > Steve > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
