Re: [PATCHES] Load distributed checkpoint patch

From: "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, "Bruce Momjian" <bruce(at)momjian(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Load distributed checkpoint patch
Date: 2006-12-20 12:05:41
Message-ID: 03be01c7242f$2b4ce130$19527c0a@OPERAO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

From: "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
> Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> Do you use the same delay autovacuum uses?
>
> What do you mean 'the same delay'? Autovacuum does VACUUM, not
CHECKPOINT.
> If you think cost-based-delay, I think we cannot use it here. It's
hard to
> estimate how much checkpoints delay by cost-based sleeping, but we
should
> finish asynchronous checkpoints by the start of next checkpoint. So
I gave
> priority to punctuality over load smoothing.

I consider that smoothing the load (more meaningfully, response time)
has higher priority over checkpoint punctuality in a practical sense,
because the users of a system benefit from good steady response and
give good reputation to the system. If the checkpoint processing is
not punctual, crash recovery would take longer time. But which would
you give higher priority, the unlikely event (=crash of the system) or
likely event (=peek hours of the system)? I believe the latter should
be regarded. The system can write dirty buffers after the peek hours
pass. User experience should be taken much case of.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-12-20 12:06:54 Re: column ordering, was Re: [PATCHES] Enums patch v2
Previous Message Gurjeet Singh 2006-12-20 12:02:18 Re: Fw: Fw: choosing use an index or not

Browse pgsql-patches by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-12-20 12:06:54 Re: column ordering, was Re: [PATCHES] Enums patch v2
Previous Message Russell Smith 2006-12-20 11:33:53 Re: column ordering, was Re: [PATCHES] Enums patch v2