| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum stopped running |
| Date: | 2010-05-03 13:52:06 |
| Message-ID: | 4BDE8EB6020000250003116F@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Benjamin Krajmalnik" <kraj(at)illumen(dot)com> wrote:
> This happened again on another server with these same settings.
> I did not see any long running transaction, and the autovacuum
> launch process was running.
Like last time, all ten autovacuum workers were running? What does
CPU and disk activity look like in this state? The contents of
pg_locks might yield a clue. If you have all ten workers showing on
the task list, but they don't seem to be making much progress,
connecting to each with gdb (or equivalent) and getting a backtrace
might be useful.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-05-03 13:52:35 | Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets |
| Previous Message | Alvaro Herrera | 2010-05-03 13:47:38 | Re: Autovacuum stopped running |