Tom Lane wrote:
Alan Stange <[EMAIL PROTECTED]> writes:
Vivek Khera wrote:
what evidence do you have that you are suffering index bloat?
The files for the two indices on a single table used 7.8GB of space
before a reindex, and 4.4GB after.
That's not bloat ... that's pretty nearly in line with the normal
expectation for a btree index, which is about 2/3rds fill factor.
If the compacted index were 10X smaller then I'd agree that you have
a bloat problem.
I wrote "I don't think this counts as bloat...". I still don't.
-- Alan
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
