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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6676: checkpointer does not work by SIGINT.
Date: 2012-06-06 17:05:24
Message-ID: 12124.1339002324@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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: Basil PeaceDate: 2012-06-06 19:04:39
Subject: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
Previous:From: Jaime CasanovaDate: 2012-06-06 12:02:16
Subject: Re: version of postgreSQL

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