Re: Accounting for metapages in genericcostestimate() - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: Accounting for metapages in genericcostestimate()
Date
Msg-id 202504301047.ek6tfqtkoz32@alvherre.pgsql
Whole thread Raw
In response to Re: Accounting for metapages in genericcostestimate()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Accounting for metapages in genericcostestimate()
List pgsql-hackers
On 2025-Apr-28, Tom Lane wrote:

> @@ -135,6 +141,7 @@ typedef struct
>      double        numIndexTuples; /* number of leaf tuples visited */
>      double        spc_random_page_cost;    /* relevant random_page_cost value */
>      double        num_sa_scans;    /* # indexscans from ScalarArrayOpExprs */
> +    BlockNumber numNonLeafPages;    /* # of index pages that are not leafs */
>  } GenericCosts;

The idea you described seems quite reasonable, though I didn't review
the patch in detail.

I find the use of "leafs" as plural for "leaf" a bit strange ...
We already have uses of that word, but I wonder if they don't mostly
or exclusively come from non-native English speakers.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Enhancing Memory Context Statistics Reporting
Next
From: Alexander Korotkov
Date:
Subject: Re: Some problems regarding the self-join elimination code