Re: Proposal for enabling auto-vectorization for checksum calculations

John Naylor <johncnaylorls@gmail.com>

From: John Naylor <johncnaylorls@gmail.com>
To: Andrew Kim <tenistarkim@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org, Oleg Tselebrovskiy <o.tselebrovskiy@postgrespro.ru>
Date: 2025-11-18T04:48:12Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Use AVX2 for calculating page checksums where available

  2. Refactor checksumming code to make it easier to use externally.

On Tue, Nov 18, 2025 at 10:32 AM Andrew Kim <tenistarkim@gmail.com> wrote:

> I've double-checked everything after applying the v9 checksum patches
> and updating pg_filedump accordingly.
> Following your suggestion, I removed the checksum_impl.h include and
> the Assert redefinition, keeping only the port/checksum.h include.
> build compiles cleanly with the new architecture, and pg_filedump
> functions correctly with the AVX2 optimizations.
> If you agree with this approach, I'd like to prepare a patch for
> upstream submission.

Thanks, but there is no action required now. I mentioned some
observations, and I'm going to experiment a bit further.

Also, it's way too early to be suggesting changes to other projects,
since we haven't committed anything yet. Even things committed can
occasionally be reverted before beta 1 anyway.
-- 
John Naylor
Amazon Web Services