Tom Lane wrote:
[EMAIL PROTECTED] writes: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...
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.
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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
