Clustering system tables

From: "Julian Scarfe" <julian(at)avbrief(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Clustering system tables
Date: 2005-03-27 17:59:06
Message-ID: 035901c532f6$ac576740$0600a8c0@Wilbur
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-27 19:19:40 Re: Clustering system tables
Previous Message Dan Sugalski 2005-03-27 17:38:49 Server load planning