Re: statement_timeout

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marcin Mańk <marcin(dot)mank(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: statement_timeout
Date: 2006-11-21 17:02:47
Message-ID: 1164128568.3841.374.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, 2006-11-16 at 13:50 -0500, Tom Lane wrote:
> =?iso-8859-2?Q?Marcin_Ma=F1k?= <marcin(dot)mank(at)gmail(dot)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?

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-11-21 17:14:17 Re: statement_timeout
Previous Message David Fetter 2006-11-21 16:43:24 Re: where to download postgresql-server-7.2.2-1.i386.rpm?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-11-21 17:14:17 Re: statement_timeout
Previous Message Tom Lane 2006-11-21 16:36:01 Re: quick review