[GENERAL] Clustering system tables

[Julian Scarfe]

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 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])