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
