| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: checkpointer code behaving strangely on postmaster -T |
| Date: | 2012-05-10 06:27:32 |
| Message-ID: | 20840.1336631252@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> I noticed while doing some tests that the checkpointer process does not
> recover very nicely after a backend crashes under postmaster -T (after
> all processes have been kill -CONTd, of course, and postmaster told to
> shutdown via Ctrl-C on its console). For some reason it seems to get
> stuck on a loop doing sleep(0.5s) In other case I caught it trying to
> do a checkpoint, but it was progressing a single page each time and then
> sleeping. In that condition, the checkpoint took a very long time to
> finish.
Is this still a problem as of HEAD? I think I've fixed some issues in
the checkpointer's outer loop logic, but not sure if what you saw is
still there.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2012-05-10 06:32:52 | Re: bgwriter idle-mode behavior (was Re: Latch for the WAL writer) |
| Previous Message | Robert Haas | 2012-05-10 06:01:29 | Re: libpq URL syntax vs SQLAlchemy |