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 |
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 |