On Mon, 16 Dec 2002, Josh Berkus wrote: > Tom, Folks: > > Joe and I were discussing your recent discussion about the costs of VACUUM and > tuple maintainence, and I had an interesting idea. > > How hard would it be to add a "WITH (VACUUM)" option to UPDATE and DELETE > queries? This option would cause the regular vacuum activity -- purging the > dead tuple and its index references -- to be done immediately, as part of the > statement, instead of being deferred. > > I agree that we don't want immediate tuple maintainence, most of the time. > However, a couple of my clients would really like to have a few queries do > their vacuum immediately, and are currently getting around that by vacuuming > every 5 mintutes. > > Easy? Hard? Insane? What do you think?
Just curious, but wouldn't it be just as simple to issue a VACUUM call right after the UPDATE/DELETE? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
