Postgres Pro
Downloads
Home   >   mailing lists

Re: Improving btree performance through specializing by key shape, take 2 - Mailing list pgsql-hackers

From Matthias van de Meent
Subject Re: Improving btree performance through specializing by key shape, take 2
Date
Msg-id CAEze2WiczWe3xSbOMLpk8+BCx9nYBoKuGgo2qygbSJ-eN1yDwg@mail.gmail.com
Whole thread Raw
In response to Re: Improving btree performance through specializing by key shape, take 2  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
Responses Re: Improving btree performance through specializing by key shape, take 2
List pgsql-hackers
Tree view 
On Mon, 4 Jul 2022 at 16:18, Matthias van de Meent
<boekewurm+postgres@gmail.com> wrote:
>
> On Sun, 5 Jun 2022 at 21:12, Matthias van de Meent
> <boekewurm+postgres@gmail.com> wrote:
> > While working on benchmarking the v2 patchset, I noticed no
> > improvement on reindex, which I attributed to forgetting to also
> > specialize comparetup_index_btree in tuplesorth.c. After adding the
> > specialization there as well (attached in v3), reindex performance
> > improved significantly too.
>
> PFA version 4 of this patchset. Changes:

Version 5 now, which is identical to v4 except for bitrot fixes to
deal with f58d7073.

Kind regards,

Matthias van de Meent.
Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Slow standby snapshot
Next
From: Simon Riggs
Date:
Subject: Re: [PATCH] Compression dictionaries for JSONB