Re: postgresql performance tuning

Tom Lane wrote:
> Alan Stange  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