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/5523~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/5523
Choose a head ref
  • 4 commits
  • 6 files changed
  • 3 contributors

Commits on Mar 18, 2025

  1. vacuumdb: Teach vacuum_one_database() to reuse query results. 

    Presently, each call to vacuum_one_database() performs a catalog
query to retrieve the list of tables to process.  A proposed
follow-up commit would add a "missing only" feature to
--analyze-in-stages, which requires us to save the results of the
catalog query (since tables without statistics would have them
after the first stage).  This commit adds this ability via a new
parameter for vacuum_one_database() that specifies either a
previously-retrieved list to process or a place to return the
results of the catalog query.  Note that this commit does not make
use of this new parameter for anything.  That is left for a
follow-up commit.

Author: Corey Huinker <[email protected]>
Co-authored-by: Nathan Bossart <[email protected]>
Reviewed-by: John Naylor <[email protected]>
Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan
    @nathan-bossart
    2 people authored and Commitfest Bot committed Mar 18, 2025
    Configuration menu
    Copy the full SHA
    189694d View commit details
    Browse the repository at this point in the history

  2. vacuumdb: Add option for analyzing only relations missing stats. 

    This commit adds a new --missing-only option that can be used in
conjunction with --analyze-only or --analyze-in-stages.  When this
option is specified, vacuumdb will generate ANALYZE commands for a
relation if it is missing any statistics it should ordinarily have.
For example, if a table has statistics for one column but not
another, we will analyze the whole table.  A similar principle
applies to extended statistics, expression indexes, and table
inheritance.

Author: Corey Huinker <[email protected]>
Co-authored-by: Nathan Bossart <[email protected]>
Reviewed-by: John Naylor <[email protected]>
Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan
    @nathan-bossart
    2 people authored and Commitfest Bot committed Mar 18, 2025
    Configuration menu
    Copy the full SHA
    25f1a36 View commit details
    Browse the repository at this point in the history

  3. Update guidance for running vacuumdb after pg_upgrade. 

    Now that pg_upgrade can carry over most optimizer statistics, we
should recommend using vacuumdb's new --missing-only option to only
analyze relations that are missing statistics.

Reviewed-by: John Naylor <[email protected]>
Discussion: https://postgr.es/m/Z5O1bpcwDrMgyrYy%40nathan
    @nathan-bossart
    nathan-bossart authored and Commitfest Bot committed Mar 18, 2025
    Configuration menu
    Copy the full SHA
    1eddc1e View commit details
    Browse the repository at this point in the history

  4. [CF 5523] v7 - vacuumdb changes for stats import/export 

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

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

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/Z9jXuyymBSVDw9pv@nathan
Author(s): Corey Huinker, Nathan Bossart
    Commitfest Bot committed Mar 18, 2025
    Configuration menu
    Copy the full SHA
    6995c08 View commit details
    Browse the repository at this point in the history
Loading