Re: statement_timeout

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: statement_timeout
Дата
Msg-id 9442.1164129257@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: statement_timeout  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: statement_timeout  ("Simon Riggs" <simon@2ndquadrant.com>)
Re: [HACKERS] statement_timeout  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-general
"Simon Riggs" <simon@2ndquadrant.com> writes:
> On Thu, 2006-11-16 at 13:50 -0500, Tom Lane wrote:
>> =?iso-8859-2?Q?Marcin_Ma=F1k?= <marcin.mank@gmail.com> writes:
>>> I have an unconfirmed feeling that autovac does not like system-wide
>>> statement_timeout.
>>
>> If you have it set to less than the time needed to do a vacuum, then
>> yes, autovac will fail.  You expected differently?  Do you think it's
>> a good idea for autovac to ignore statement_timeout?  (Maybe it is,
>> but I suspect we'd get complaints about that too.)

> Autovac *must* ignore statement_timeout if it is doing a wraparound
> avoidance scan, surely?

Hmm.  Good point.  Shall we just make it ignore statement_timeout all
the time, then?  We already have it overriding zero_damaged_pages ...

            regards, tom lane

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: statement_timeout
Следующее
От: Bob Pawley
Дата:
Сообщение: Download