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? -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
