Re: BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout
Date
Msg-id 200411021450.iA2EogG18102@candle.pha.pa.us
Whole thread Raw
In response to BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Alex Koh wrote:
> I agree with the suggestions to attach it to userids. However, setting the
> statement_timeout in the conf file is good as it will enforce everyone to
> have some timeout. This will be especially useful in web applications.
>
> Anyway, I will use ALTER USER to do it and disable statement_timeout in the
> conf file.

Yep, that's how I would do it.  If you want it on in the config file you
should turn it off for super-users.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1303: backend crashes due wrong TCP packet
Next
From: Josh Berkus
Date:
Subject: Re: [pgsql-bugs] Daily digest v1.1281 (14 messages)