Re: Is there a way to limit CPU usage per user

Csaba Nagy <nagy@ecircle-ag.com> 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