Re: statement_timeout

> If you have it set to less than the time needed to do a vacuum, then
> yes, autovac will fail.  You expected differently?  Do you think it's
> a good idea for autovac to ignore statement_timeout?  (Maybe it is,
> but I suspect we'd get complaints about that too.)
>

"alter role set statement_timeout" solves my immediate problem (I did not
know about it, thanks guys). Maybe a comment in postgresql.conf, or docs:

# note: statement_timeout applies to autovacuum, pg_dump, vacuumdb etc.
# If you set it globally, consider "alter role postgres set
statement_timeout=0"


Greetings
Marcin Mańk