Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5786~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5786
Choose a head ref
  • 6 commits
  • 18 files changed
  • 2 contributors

Commits on Jul 10, 2025

  1. Rename CHECKPOINT_FLUSH_ALL to CHECKPOINT_FLUSH_UNLOGGED. 

    The new name more accurately indicates the effects of this flag on
a requested checkpoint.  Checkpoint-related log messages (i.e.,
those controlled by the log_checkpoints configuration parameter)
will now say "flush-unlogged" instead of "flush-all", too.  This is
preparatory work for a follow-up commit that will add a
FLUSH_UNLOGGED option to the CHECKPOINT command.

Author: Christoph Berg <[email protected]>
Discussion: https://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de
    @nathan-bossart
    nathan-bossart authored and Commitfest Bot committed Jul 10, 2025
    Configuration menu
    Copy the full SHA
    55999bc View commit details
    Browse the repository at this point in the history

  2. Rename CHECKPOINT_IMMEDIATE to CHECKPOINT_FAST. 

    The new name more accurately indicates the effects of this flag on
a requested checkpoint.  Checkpoint-related log messages (i.e.,
those controlled by the log_checkpoints configuration parameter)
will now say "fast" instead of "immediate", too.  And references to
"immediate" checkpoints in the documentation have been updated to
say "fast" instead.  This is preparatory work for a follow-up
commit that will add a MODE option to the CHECKPOINT command.

Author: Christoph Berg <[email protected]>
Discussion: https://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de
    @nathan-bossart
    nathan-bossart authored and Commitfest Bot committed Jul 10, 2025
    Configuration menu
    Copy the full SHA
    d27d5e1 View commit details
    Browse the repository at this point in the history

  3. Add option list to CHECKPOINT command. 

    This commit adds the boilerplate code for supporting a list of
options in CHECKPOINT commands.  No actual options are supported
yet, but follow-up commits will add support for MODE and
FLUSH_UNLOGGED.  While at it, this commit refactors the code for
executing CHECKPOINT commands to its own function since it's about
to become significantly longer.

Author: Christoph Berg <[email protected]>
Reviewed-by: Fujii Masao <[email protected]>
Discussion: https://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de
    @nathan-bossart
    nathan-bossart authored and Commitfest Bot committed Jul 10, 2025
    Configuration menu
    Copy the full SHA
    c25e7bf View commit details
    Browse the repository at this point in the history

  4. Add MODE option to CHECKPOINT command. 

    This option may be set to FAST (the default) to request the
checkpoint be completed as fast as possible, or SPREAD to request
the checkpoint be spread over a longer interval (based on the
checkpoint-related configuration parameters).  Note that the server
may consolidate the options for concurrently requested checkpoints.
For example, if one session requests a "fast" checkpoint and
another requests a "spread" checkpoint, the server may perform one
"fast" checkpoint.

Author: Christoph Berg <[email protected]>
Reviewed-by: Andres Freund <[email protected]>
Reviewed-by: Fujii Masao <[email protected]>
Reviewed-by: Laurenz Albe <[email protected]>
Reviewed-by: Dilip Kumar <[email protected]>
Discussion: https://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de
    @nathan-bossart
    nathan-bossart authored and Commitfest Bot committed Jul 10, 2025
    Configuration menu
    Copy the full SHA
    8922371 View commit details
    Browse the repository at this point in the history

  5. Add FLUSH_UNLOGGED option to CHECKPOINT command. 

    This option, which is disabled by default, can be used to request
the checkpoint also flush data files for 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 <[email protected]>
Reviewed-by: Laurenz Albe <[email protected]>
Reviewed-by: Fujii Masao <[email protected]>
Reviewed-by: Dilip Kumar <[email protected]>
Discussion: https://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de
    @nathan-bossart
    nathan-bossart authored and Commitfest Bot committed Jul 10, 2025
    Configuration menu
    Copy the full SHA
    7c157ac View commit details
    Browse the repository at this point in the history

  6. [CF 5786] v9 - CHECKPOINT unlogged data 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5786

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/aG_kOm3bkKVKjmhI@nathan
Author(s): Christoph Berg
    Commitfest Bot committed Jul 10, 2025
    Configuration menu
    Copy the full SHA
    da67ae6 View commit details
    Browse the repository at this point in the history
Loading