Re: About System Catalogs

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