pgsql: Add FLUSH_UNLOGGED option to CHECKPOINT command.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add FLUSH_UNLOGGED option to CHECKPOINT command.
Date: 2025-07-11 16:52:09
Message-ID: E1uaGyn-005mrN-1u@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add FLUSH_UNLOGGED option to CHECKPOINT command.

This option, which is disabled by default, can be used to request
the checkpoint also flush dirty buffers of unlogged relations. As
with the MODE option, the server may consolidate the options for
concurrently requested checkpoints. For example, if one session
uses (FLUSH_UNLOGGED FALSE) and another uses (FLUSH_UNLOGGED TRUE),
the server may perform one checkpoint with FLUSH_UNLOGGED enabled.

Author: Christoph Berg <myon(at)debian(dot)org>
Reviewed-by: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Reviewed-by: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
Reviewed-by: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Discussion: https://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8d33fbacbac93ed70757ea47cd8a4b4fae61528a

Modified Files
--------------
doc/src/sgml/ref/checkpoint.sgml | 26 ++++++++++++++++++++++++++
src/backend/postmaster/checkpointer.c | 4 ++++
src/bin/psql/tab-complete.in.c | 2 +-
src/test/regress/expected/stats.out | 4 ++--
src/test/regress/sql/stats.sql | 4 ++--
5 files changed, 35 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jacob Champion 2025-07-11 17:32:42 pgsql: oauth: Run Autoconf tests with correct compiler flags
Previous Message Tom Lane 2025-07-11 16:49:26 pgsql: Force LC_NUMERIC to C while running TAP tests.