I've got a database (7.4) whose system tables have been long neglected.
Instead of the 100 or so pages I'd expect for 4000 rows after VACUUM, I've
got 24,000 pages and a mere 1.4 million unused item pointers.
If it were an ordinary table, I'd CLUSTER it, as from experience it would be
vastly quicker than a VACUUM FULL. But CLUSTER responds with:
ERROR: "pg_attribute" is a system catalog
Is VACUUM FULL my only option to compact the table?
Julian Scarfe