Tom Lane wrote:
> Alan Stange <stange@rentec.com> 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
