| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum stopped running |
| Date: | 2010-05-01 14:26:33 |
| Message-ID: | 4BDBF3C90200002500031147@gw.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Benjamin Krajmalnik" <kraj(at)illumen(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2010-05-01 14:41:50 | Re: Very Dangerous bug in XA connection pooling and SL EJBs with jboss-4.2.3 & latest postgresql-8.4-701.jdbc3.jar |
| Previous Message | Gavin Kistner | 2010-05-01 02:44:51 | Re: Fresh build on OS X not working (memory) |