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. Thanks! Alex Koh -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 11:48 AM To: Alex Koh Cc: [EMAIL PROTECTED] Subject: Re: [BUGS] BUG #1302: Vacuumdb and vacuumlo should disable statement_timeout "PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
