Re: Accounting for metapages in genericcostestimate()

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема Re: Accounting for metapages in genericcostestimate()
Дата
Msg-id 202504301047.ek6tfqtkoz32@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Accounting for metapages in genericcostestimate()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Accounting for metapages in genericcostestimate()
Список 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 по дате отправления: