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: 4FD007E3.2030706@po.ntts.co.jp (view raw or flat)
Thread:
Lists: 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(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:
>
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
>



In response to

Responses

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-2014 The PostgreSQL Global Development Group