Postgres Pro
Downloads
Home   >   mailing lists

Re: Speed up collation cache - Mailing list pgsql-hackers

From John Naylor
Subject Re: Speed up collation cache
Date
Msg-id CANWCAZZuv==Hx96DOVGAEAwMfj9YohgQHHw2SCnO6U6cxCcBBg@mail.gmail.com
Whole thread Raw
In response to Speed up collation cache  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Tree view 
On Sat, Jun 15, 2024 at 6:46 AM Jeff Davis <pgsql@j-davis.com> wrote:
> Attached is a patch to use simplehash.h instead, which speeds things up
> enough to make them fairly close (from around 15% slower to around 8%).

+#define SH_HASH_KEY(tb, key)   hash_uint32((uint32) key)

For a static inline hash for speed reasons, we can use murmurhash32
here, which is also inline.

pgsql-hackers by date:

Previous
From: Japin Li
Date:
Subject: How about add counted_by attribute for flexible-array?
Next
From: Hannu Krosing
Date:
Subject: Re: DROP OWNED BY fails to clean out pg_init_privs grants