Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row

From: "Drouvot, Bertrand" <bdrouvot(at)amazon(dot)com>
To: Hamid Akhtar <hamid(dot)akhtar(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row
Date: 2022-07-01 08:01:33
Message-ID: 477be374-f020-aa88-78c3-dd594d0863cf@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 6/30/22 10:24 AM, Hamid Akhtar wrote:
> On Mon, 27 Jun 2022 at 15:52, Bharath Rupireddy
> <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
>
> On Mon, Jun 27, 2022 at 1:40 PM Drouvot, Bertrand
> <bdrouvot(at)amazon(dot)com> wrote:
> >
> > Hi,
> >
> > On 6/27/22 9:31 AM, Hamid Akhtar wrote:
> >
> >
> > Hello Hackers,
> >
> > While working on one of my blogs on the B-Tree indexes, I needed
> to look at a range of B-Tree page statistics. So the goto solution
> was to use pageinspect. However, reviewing stats for multiple
> pages meant issuing multiple queries.
>
> +1 to improve the API.
>
I think it makes sense too.

But what about the other pageinspect's functions that also use a single
blkno as parameter? Should not the patch also takes care of them?

Regards,

Bertrand

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2022-07-01 08:10:46 Re: Pluggable toaster
Previous Message Drouvot, Bertrand 2022-07-01 07:48:40 Re: Patch proposal: New hooks in the connection path