Re: BUG #6676: checkpointer does not work by SIGINT. - Mailing list pgsql-bugs

From Tomonari Katsumata
Subject Re: BUG #6676: checkpointer does not work by SIGINT.
Date
Msg-id 4FD007E3.2030706@po.ntts.co.jp
Whole thread Raw
In response to Re: BUG #6676: checkpointer does not work by SIGINT.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #6676: checkpointer does not work by SIGINT.
List pgsql-bugs
Hi,

Thank you for explanation about it.

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

regards,

(2012/06/07 2:05), Tom Lane wrote:
> katsumata.tomonari@po.ntts.co.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:
>
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724
>
> 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
>

pgsql-bugs by date:

Previous
From: Basil Peace
Date:
Subject: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
Next
From: Tom Lane
Date:
Subject: Re: BUG #6676: checkpointer does not work by SIGINT.