Thomas Swan wrote:
> Tom Lane wrote:
>
>>Francesco.Borgoglio@cedacri.it writes:
>>
>>
>>>2) As i had a very large pg_largeogject, i deleted rows e now i have a
>>>clean, small table.
>>> The table is empty but its index pg_largeogject_loid_pn_index lasts
>>>to retain a lot of bytes.
>>>
>>>
>>
>>REINDEX should fix this.
>>
>>
>>
> Is REINDEX still going to be a necessity in the 8.0 release? I
> remembered at there was a discussion on the mailing list about a fix or
> need to fix VACUUM so that manually reindexing would not be necessary...
>
This is already true for the 7.4, I don't remember that vacuum was improved
int that direction in the 8.0.
Regards
Gaetano Mendola
