Horton

Re: Batch TIDs lookup in ambulkdelete

Peter Geoghegan <pg@bowt.ie>

View thread
From: Peter Geoghegan <pg@bowt.ie>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: John Naylor <johncnaylorls@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2025-06-06T23:27:46Z
Lists: pgsql-hackers 
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