Re: [GENERAL] Clustering system tables

2005-03-27 Thread Alvaro Herrera
On Sun, Mar 27, 2005 at 06:59:06PM +0100, Julian Scarfe wrote: > 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

[GENERAL] Clustering system tables

2005-03-27 Thread 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 q