| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Unresponsive vacuum process |
| Date: | 2004-05-19 23:49:12 |
| Message-ID: | 22512.1085010552@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> I have a 7.2.1 backend running VACUUM which appears to be blocking all other
> processes. I have issued SIGTERM and SIGINT directly to that backend and
> also killed the client process, but the VACUUM continues chewing up CPU and
> blocking others.
Hmph. AFAICS 7.2 does contain CHECK_FOR_INTERRUPT calls within all the
major VACUUM loops, so it should respond to SIGINT in a reasonably
timely fashion. I'd think it was blocked on someone else's lock if it
weren't that you say it's still consuming CPU. Can you attach to the
troublesome backend with gdb and get a stack trace to show where it is?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-05-19 23:56:13 | Re: [GENERAL] Question about rtrees (overleft replacing left in nodes) |
| Previous Message | Bruce Momjian | 2004-05-19 23:10:57 | Re: Documentation clairification?, CHECK constraints |