Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout
Date
Msg-id 29727.1099367300@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> IMHO vacuumdb and vacuumlo should disable statement_timeout before vacuuming
> the database.

IMHO this request suggests that you are not setting statement_timeout in
sane places.  One reasonable setup is to attach it to userids other than
the one used for vacuuming.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout
Next
From: Edgars
Date:
Subject: postgres getting slow in the latest version