Re: fast promotion and log_checkpoints

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: fast promotion and log_checkpoints
Date: 2013-05-21 14:29:15
Message-ID: CAHGQGwEyuTMskkJkFXNy2b9f8xdS0k7Pvt84P6vLodBkTgV6Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 21, 2013 at 4:44 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On 20 May 2013 20:06, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> wrote:
>
>>> It would be possible to redesign this with a special new reason, or we
>>> could just use "time" as the reason, or we could just leave it.
>>>
>>> Do nothing is easy, though so are the others, so we can choose
>>> anything we want. What do we want it to say?
>>
>>
>> I'm not sure. Perhaps we should print "(no flags)", so that it wouldn't look
>> like there's something missing in the log message.
>
> The reason text would still be absent, so it wouldn't really help the
> user interpret the log message correctly.
>
> I suggest we use RequestCheckpoint(CHECKPOINT_CAUSE_TIME) instead,
> since it is literally time for a checkpoint.

Or, what about using CHECKPOINT_FORCE and just printing "force"?
Currently that checkpoint always starts because of existence of the
end-of-recovery record, but I think we should ensure that the checkpoint
always starts by using that flag.

Regards,

--
Fujii Masao

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2013-05-21 15:02:51 Re: fast promotion and log_checkpoints
Previous Message Josh Berkus 2013-05-21 13:44:40 Re: pgbench vs. SERIALIZABLE