Simon Riggs <simon@2ndquadrant.com> writes: > Why isn't VACUUM optimised the same way HOT is? It doesn't do the same things HOT does. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster

Alvaro Herrera <alvherre@alvh.no-ip.org> writes: > Simon Riggs wrote: >> [Also there is a comment saying "this is a bug" in autovacuum.c >> Are we thinking to go production with that phrase in the code?] > Yeah, well, it's only a comment ;-) The problem is that a worker can > decide that a table needs to be vacuumed, if another worker has finished > vacuuming it in the last 500 ms. I proposed a mechanism to close the > hole but it was too much of a hassle. > Maybe we could remove the comment for the final release? :-) What, you think we should try to hide our shortcomings? There are hundreds of XXX and FIXME comments in the sources. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate