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
