Horton

Re: Proposal for enabling auto-vectorization for checksum calculations

Andrew Kim <tenistarkim@gmail.com>

View thread
From: Andrew Kim <tenistarkim@gmail.com>
To: John Naylor <johncnaylorls@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org, Oleg Tselebrovskiy <o.tselebrovskiy@postgrespro.ru>
Date: 2025-11-19T01:18:36Z
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 Mon, Nov 17, 2025 at 8:48 PM John Naylor <johncnaylorls@gmail.com> wrote:
>
> 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.

It makes sense, I fully understand. I will standby and wait for your
next update.

-Andrew Kim

> --
> John Naylor
> Amazon Web Services