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

Commits on Mar 3, 2025

  1. Trigger more frequent autovacuums with relallfrozen 

    Calculate the insert threshold for triggering an autovacuum of a
relation based on the number of unfrozen pages. By only considering the
"active" (unfrozen) portion of the table when calculating how many
tuples to add to the insert threshold, we can trigger more frequent
vacuums of insert-heavy tables and increase the chances of vacuuming
those pages when they still reside in shared buffers.

This uses the recently added (99f8f3f) relallfrozen column of
pg_class.

Reviewed-by: Nathan Bossart <[email protected]>
Reviewed-by: Greg Sabino Mullane <[email protected]>
Discussion: https://postgr.es/m/flat/CAAKRu_aj-P7YyBz_cPNwztz6ohP%2BvWis%3Diz3YcomkB3NpYA--w%40mail.gmail.com
    @melanieplageman
    melanieplageman authored and Commitfest Bot committed Mar 3, 2025
    Configuration menu
    Copy the full SHA
    72b3c09 View commit details
    Browse the repository at this point in the history

  2. [CF 5320] v12 - Trigger more frequent autovacuums for insert-heavy ta… 

    …bles

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

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

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/CAAKRu_ZeL689jPWgKGvLHB-vum81P_T=_eyR4sGozygChARaSA@mail.gmail.com
Author(s): Melanie Plageman
    Commitfest Bot committed Mar 3, 2025
    Configuration menu
    Copy the full SHA
    1d0a34a View commit details
    Browse the repository at this point in the history
Loading