Re: [GENERAL] index bloat WAS: reindexing pg_shdepend

2007-08-03 Thread Tom Lane
OK, as far as I saw you never mentioned what PG version you are running, but if it's 8.2.x then I think I know what's going on. The thing that was bothering me was the discrepancy in size of the two indexes. Now the entries in pg_shdepend_reference_index are all going to be references to roles, a

Re: [GENERAL] index bloat WAS: reindexing pg_shdepend

2007-08-03 Thread Joseph Shraibman
Tom Lane wrote: Joseph S <[EMAIL PROTECTED]> writes: ... and when I notice that the tuplesperpage for the indexes is low (or that the indexes are bigger then the tables themselves) I know it is time for a VACUUM FULL and REINDEX on that table. If you are taking the latter as a blind must-be-w