> 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: Basil Peace||Date: 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 Casanova||Date: 2012-06-06 12:02:16|
|Subject: Re: version of postgreSQL|