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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
