Postgres Pro
Downloads
Home   >   mailing lists

Re: Batch TIDs lookup in ambulkdelete - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Batch TIDs lookup in ambulkdelete
Date
Msg-id CAH2-Wzni6Xjy9imvqqt+3tvjBU1PEF+eoJBV7oaDWN4B79VA4w@mail.gmail.com
Whole thread Raw
In response to Re: Batch TIDs lookup in ambulkdelete  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Tree view 
On Fri, Jun 6, 2025 at 6:58 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> Agreed. Given the above test results, it's unlikely always sorting the
> array helps speedups.

Did you try specializing the sort? In my experience, it makes a big difference.

--
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Batch TIDs lookup in ambulkdelete
Next
From: David Rowley
Date:
Subject: Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX