Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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
