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

Commits on Nov 3, 2025

  1. Move checksum functions from backend storage to port 

    This refactoring moves checksum implementation from src/backend/storage/page/
to src/port/
    @andrewkim-pkt
    andrewkim-pkt authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    8c0bb02 View commit details
    Browse the repository at this point in the history

  2. Add AVX2 optimization for page checksum calculation 

    This patch adds runtime AVX2 detection and optimization for PostgreSQL's
page checksum algorithm while maintaining full backward compatibility.

Key changes:
- Add cross-platform AVX2 CPU detection with XSAVE/YMM register checks
- Implement function pointer dispatch pattern following PostgreSQL conventions
- Use compiler auto-vectorization with pg_attribute_target("avx2")
- Add build system support in both autotools and meson
- Maintain external program compatibility (pg_filedump, etc.)

The implementation uses the same algorithm for both default and AVX2 paths,
allowing the compiler to automatically vectorize the AVX2 version while
preserving identical results. Runtime detection ensures optimal performance
on supported hardware with graceful fallback on older systems.

Addresses reviewer feedback on configure test simplification, Windows
compatibility, and PostgreSQL coding conventions.
    @andrewkim-pkt
    andrewkim-pkt authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    8f27b3e View commit details
    Browse the repository at this point in the history

  3. Benchmark code for pg_checksum_bench performance testing 

    This extension provides benchmarking functions to test and compare
the performance of different checksum implementations
    @andrewkim-pkt
    andrewkim-pkt authored and Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    2cc1593 View commit details
    Browse the repository at this point in the history

  4. [CF 5726] v8 - Enable auto-vectorization for page checksum calculations 

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

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

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/CAK64mnejn9AZMYz03e7HX8Uui35PihUuOy=b+iBG=YtRKx0Log@mail.gmail.com
Author(s): Matthew Sterrett, Andrew Kim
    Commitfest Bot committed Nov 3, 2025
    Configuration menu
    Copy the full SHA
    fc1fba0 View commit details
    Browse the repository at this point in the history
Loading