Re: temporarily stop autovacuum
От
Bernd Helmle
Тема
Re: temporarily stop autovacuum
Дата
Msg-id
0CBDFB72109208B183692428@teje
Ответ на
Re: temporarily stop autovacuum (Robert Haas)
Список
Дерево обсуждения
temporarily stop autovacuum Tatsuo Ishii <ishii@postgresql.org>
Re: temporarily stop autovacuum "Joshua D. Drake" <jd@commandprompt.com>
Re: temporarily stop autovacuum Tatsuo Ishii <ishii@postgresql.org>
Re: temporarily stop autovacuum Peter Eisentraut <peter_e@gmx.net>
Re: temporarily stop autovacuum Alvaro Herrera <alvherre@commandprompt.com>
Re: temporarily stop autovacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: temporarily stop autovacuum Peter Eisentraut <peter_e@gmx.net>
Re: temporarily stop autovacuum Robert Haas <robertmhaas@gmail.com>
Re: temporarily stop autovacuum Bernd Helmle <mailings@oopsware.de>
Re: temporarily stop autovacuum "Joshua D. Drake" <jd@commandprompt.com>
Re: temporarily stop autovacuum Alvaro Herrera <alvherre@commandprompt.com>
Re: temporarily stop autovacuum ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: temporarily stop autovacuum Robert Haas <robertmhaas@gmail.com>
--On Mittwoch, Februar 11, 2009 13:18:11 -0500 Robert Haas
wrote:
> In any case it's not difficult to write a script that loops over all
> of your tables with ALTER TABLE. It's probably not as fast as a
> single UPDATE statement, but I suspect you'd need to have an enormous
> number of tables for that to matter much.
Agreed, we often recommend this for all kinds of GRANTs, REVOKEs and so on.
But while we don't have (yet) any facility to achieve this behavior with
these commands, for autovacuum, a possible solution exists, and although a
crude temporarily one, i know people seeing pg_autovacuum as a feature to
do exactly this kind of maintenance.
-- Thanks
Bernd
В списке pgsql-hackers по дате отправления
