Re: pg_attribute size

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