Suggestion; "WITH VACUUM" option
От | Josh Berkus |
---|---|
Тема | Suggestion; "WITH VACUUM" option |
Дата | |
Msg-id | 200212161400.53021.josh@agliodbs.com обсуждение исходный текст |
Ответы |
Re: Suggestion; "WITH VACUUM" option
Re: Suggestion; "WITH VACUUM" option |
Список | pgsql-hackers |
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 BerkusAglio Database SolutionsSan Francisco
В списке pgsql-hackers по дате отправления: