| From: | John Naylor <johncnaylorls(at)gmail(dot)com> |
|---|---|
| To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 18 GA press release draft |
| Date: | 2025-09-10 13:52:31 |
| Message-ID: | CANWCAZaVL4mjBYXi0uUYMA6Pwijebd36OriJcyHf_PfagPLkWg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Sep 10, 2025 at 10:13 AM Jonathan S. Katz <jkatz(at)postgresql(dot)org> wrote:
> PostgreSQL 18 also supports using x86 AVX-512 instructions for CRC32 calculations, which are used in page checksums and are also available in the new [`crc32`](https://www.postgresql.org/docs/18/functions-binarystring.html#FUNCTIONS-BINARYSTRING-OTHER) function.
Hi Jon,
The checksum stored in the page header is not actually a CRC but
something else entirely. WAL records are a convenient example of
something that uses CRC.
Also, CRC32 is not hardware accelerated, only CRC32C is. We have two
SQL-callable functions. To avoid confusion maybe they can be omitted
from this longer-than-usual announcement -- they seem like a niche
feature anyway.
--
John Naylor
Amazon Web Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Natalya Aksman | 2025-09-10 13:52:33 | Re: Adding skip scan (including MDAM style range skip scan) to nbtree |
| Previous Message | Marcos Pegoraro | 2025-09-10 13:29:45 | Re: [PATCH] Generate random dates/times in a specified range |