"Benjamin Krajmalnik" <kraj@illumen.com> wrote:
> I had a very strange occurrence 2 days ago where autovacuum
> appears to have stopped running.
What did you see which led you to that conclusion? Did ps show the
'autovacuum launcher process'?
> I did not see any error messages in pg_log. The problem caused a
> file which is usually around 50Mb but which gets updated
> extensively to grow to 105GB, which in turn brought the server's
> performance down to unusable levels.
Were there any long-running transactions showing in
pg_stat_activity? (That would include transactions showing '<IDLE>
in transaction'.)
-Kevin