Re: CHECKPOINT unlogged data

From: Christoph Berg <myon(at)debian(dot)org>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: CHECKPOINT unlogged data
Date: 2025-06-16 15:43:54
Message-ID: aFA7ustE2APIMehs@msg.df7cb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Re: Nathan Bossart
> I think you've got it right. With CHECKPOINT_WAIT set, RequestCheckpoint()
> will wait for a new checkpoint to start, at which point we know that the
> new flags have been seen by the checkpointer. If an immediate checkpoint
> is pending, CheckpointWriteDelay() will skip sleeping in the
> currently-running one, so the current checkpoint will be "upgraded" to
> immediate in some sense, but IIUC there will still be another immediate
> checkpoint after it completes. But AFAICT it doesn't pick up
> FLUSH_UNLOGGED until the next checkpoint begins.

> Another thing to note is what I mentioned earlier:

Thanks. I now have this:

<para>
If a checkpoint is already running when a <command>CHECKPOINT</command>
is issued, a new checkpoint is queued. The server will consolidate multiple
concurrently requested checkpoints or restartpoints and merge their options.
For example, if one session requests a fast checkpoint and another session
requests a spread checkpoint, the server combines these requests and
performs one fast checkpoint. Queing a fast checkpoint will also switch a
currently running spread checkpoint to run fast.
</para>

Christoph

Attachment Content-Type Size
v6-0001-Rename-checkpoint-options-immediate-and-flush-all.patch text/x-diff 17.7 KB
v6-0002-Add-mode-and-flush_unlogged-options-to-CHECKPOINT.patch text/x-diff 11.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Konstantin Knizhnik 2025-06-16 15:48:27 Re: Non-reproducible AIO failure
Previous Message Daniel Gustafsson 2025-06-16 15:41:10 Re: No error checking when reading from file using zstd in pg_dump