From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Rick Gigger <rick(at)alpinenetworking(dot)com> |
Cc: | Ragnar <gnari(at)hive(dot)is>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: query timeout |
Date: | 2006-03-03 10:14:20 |
Message-ID: | 1141380860.3327.69.camel@coppola.muc.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I asked the same question some time ago, and IIRC the answer was that
the statement timeout only applies to interactive sessions. So
autovacuum would not be affected, but a vacuum run through psql yes.
You can also set it for a user (see "alter user ... set ..."), and use
separate users for application access and maintenance work.
Cheers,
Csaba.
On Fri, 2006-03-03 at 11:03, Rick Gigger wrote:
> Oh that will abort vacuum after that time as well? Can anyone
> confirm that this is the case? There shouldn't be ANY queries that
> take that long and if there are then can manually set the parameter
> when those requests happen. I would prefer to limit by default and
> allow longer queries only when I specify. But if it kills vacuum I
> will have to take a different approach.
>
> On Mar 3, 2006, at 2:59 AM, Ragnar wrote:
>
> > On fim, 2006-03-02 at 11:03 -0700, Rick Gigger wrote:
> >> Never-mind that. I'm assuming statement_timeout is what I need?
> >
> > Yes, but take care if you change this in postgresql.conf:
> > some queries might reasonaby be expected to take longer
> > than 5 minutes, such as VACUUM.
> >
> > gnari
> >
> >> On Mar 2, 2006, at 11:01 AM, Rick Gigger wrote:
> >>
> >>> Is there a way to put a timeout on a query so that if it runs
> >>> longer than 5 minutes or something it is just automatically
> >>> terminated?
> >
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-03-03 10:23:21 | Re: Physical column size |
Previous Message | Rick Gigger | 2006-03-03 10:03:33 | Re: query timeout |