"Benjamin Krajmalnik" <kraj@xxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
