Postgres Pro
Downloads
Home   >   mailing lists

Re: A potential memory leak on Merge Join when Sort node is not below Materialize node - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: A potential memory leak on Merge Join when Sort node is not below Materialize node
Date
Msg-id CAH2-Wz=jrnCVydbwSHwnE3DZ_gALxHpf9kJ-QjfBsZQz+p-VaA@mail.gmail.com
Whole thread Raw
In response to Re: A potential memory leak on Merge Join when Sort node is not below Materialize node  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, Sep 28, 2022 at 9:59 PM David Rowley <dgrowleyml@gmail.com> wrote:
> select b from t1 order by b offset 1000000;
>
> Master:
> latency average = 344.763 ms
>
> Patched:
> latency average = 268.374 ms
>
> about 28% faster.

That's more like it!

-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Have nodeSort.c use datum sorts single-value byref types
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: more descriptive message for process termination due to max_slot_wal_keep_size