Skip site navigation (1) Skip section navigation (2)

Re: BUG #6676: checkpointer does not work by SIGINT.

From: Tomonari Katsumata <katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6676: checkpointer does not work by SIGINT.
Date: 2012-06-07 01:46:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

Thank you for explanation about it.

I've understood that it is intended thing.
Sorry to bother you.


(2012/06/07 2:05), Tom Lane wrote:
> katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp writes:
>> Now I'm testing the behavior of checkpointer,
>> and I found a difference with PostgreSQL9.1 behavior.
>> When I send SIGINT signal to writer process on PostgreSQL9.1,
>> writer process starts checkpoint.
>> But, when I send SIGINT signal to checkpointer on PostgreSQL9.2beta2,
>> checkpointer doesn't start checkpoint.
> AFAICT, the checkpointer does consider starting a checkpoint, but it
> decides not to do one, because of this recent change:
> If you had done enough updates since the last checkpoint, it would do
> one. So this isn't a bug, but an intentional reduction in checkpoint
> frequency. (Note that sending SIGINT is not, and never has been,
> equivalent to forcing a checkpoint.)
> regards, tom lane

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2012-06-07 02:04:39
Subject: Re: BUG #6676: checkpointer does not work by SIGINT.
Previous:From: Dave PageDate: 2012-06-06 19:07:26
Subject: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group