Bruce Momjian escribió:
> The release note item says we can now reclaim without vacuum:
>
> "UPDATE"s and "DELETE"s leave dead tuples behind, as do failed
> "INSERT"s. Previously only "VACUUM" could reclaim
> space taken by dead tuples. With HOT dead tuple space can be
> automatically reclaimed at the time of "INSERT" or ...
>
> so it seems logical that the need to vacuum would change. We can add
> an explicit sentence about that to the release notes.
Ok, but the problem is not only realizing that you need to change it;
you also need to know what to.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support