Re: Speed up collation cache

From: John Naylor <johncnaylorls(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Speed up collation cache
Date: 2024-06-20 10:07:23
Message-ID: CANWCAZZuv==Hx96DOVGAEAwMfj9YohgQHHw2SCnO6U6cxCcBBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jun 15, 2024 at 6:46 AM Jeff Davis <pgsql(at)j-davis(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2024-06-20 10:14:19 Re: DROP OWNED BY fails to clean out pg_init_privs grants
Previous Message Japin Li 2024-06-20 10:02:38 How about add counted_by attribute for flexible-array?