Downloads
Home   >   mailing lists

Re: index prefetching - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: index prefetching
Date
Msg-id CAH2-Wzk0d+fdfMTwUx8friA7NFoSh=JJOb9qXaD2_dXsuuue3A@mail.gmail.com
Whole thread Raw
In response to Re: index prefetching  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
On Tue, Jul 22, 2025 at 1:35 PM Peter Geoghegan <pg@bowt.ie> wrote:
> I attach pgbench_accounts_pkey_nhblks.txt, which shows a query that
> (among other things) ouputs "nhblks" for each leaf page from a given
> index (while showing the details of each leaf page in index key space
> order).

I just realized that my terminal corrupted the SQL query (but not the results).

Attached is a valid and complete version of the same query.

--
Peter Geoghegan
Attachment

pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Making jsonb_agg() faster
Next
From: Marcos Pegoraro
Date:
Subject: Re: Proposal: QUALIFY clause