Re: Autovacuum vs statement_timeout

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Autovacuum vs statement_timeout
Дата
Msg-id 200704180233.l3I2XL226380@momjian.us
обсуждение исходный текст
Ответ на Re: Autovacuum vs statement_timeout  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Autovacuum vs statement_timeout  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Alvaro Herrera wrote:
> I think that is too strong an assumption, which is why I'm planning to
> back-patch the change to reset statement_timeout to 0 on autovacuum till
> 8.0, as discussed.  I think I should also backpatch the change to set
> zero_damaged_pages as well (which is not on 8.0 AFAIR).
> 
> It's very very easy to change things in postgresql.conf.  Actually
> knowing what you are doing (i.e. thinking on the consequences on VACUUM
> and such) is a whole another matter.

Frankly, setting statement_timeout in postgresql.conf seems so risky in
so many ways, perhaps we just need to document that the parameter
probably should not be set in postgresql.conf, and why.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Update error message for COPY with a multi-byte delimiter.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Hacking on PostgreSQL via GIT