Csaba Nagy <[EMAIL PROTECTED]> writes: > How does this apply to autovacuum's long running vacuum commands ? Cause > I have one table where the last vacuum took 15 hours :-)
[ Checks code... ] No, statement_timeout only applies to commands arriving from an interactive client. This *would* be a hazard for the contrib version of autovacuum, but not for the 8.1 integrated version. (If you're using contrib autovacuum, it'd be a good idea to do "ALTER USER SET statement_timeout = 0" for the user it runs as.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly