I assume that running the vacuumdb command is the same as running it
through psql?
On Mar 3, 2006, at 3:14 AM, Csaba Nagy wrote:
> 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
>
>