Search Postgresql Archives

Re: statement_timeout

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Simon Riggs" <simon@xxxxxxxxxxxxxxx> writes:
> On Thu, 2006-11-16 at 13:50 -0500, Tom Lane wrote:
>> =?iso-8859-2?Q?Marcin_Ma=F1k?= <marcin.mank@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux