Re: Hypothetical indexes using BRIN broken since pg10
От | Alvaro Herrera |
---|---|
Тема | Re: Hypothetical indexes using BRIN broken since pg10 |
Дата | |
Msg-id | 20190627192420.GA1028@alvherre.pgsql обсуждение исходный текст |
Ответ на | Re: Hypothetical indexes using BRIN broken since pg10 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Hypothetical indexes using BRIN broken since pg10
|
Список | pgsql-hackers |
On 2019-Jun-27, Tom Lane wrote: > Alvaro Herrera <alvherre@2ndquadrant.com> writes: > > On 2019-Jun-27, Tom Lane wrote: > >> FWIW, the proposed patch doesn't seem to me like it adds much more > >> BRIN-specific knowledge to brincostestimate than is there already. > > > It's this calculation that threw me off: > > statsData.revmapNumPages = (indexRanges / REVMAP_PAGE_MAXITEMS) + 1; > > ISTM that selfuncs has no reason to learn about revmap low-level > > details. > > Um ... it's accounting for revmap pages already (which is why it needs > this field set), so hasn't that ship sailed? Yes, but does it need to know how many items there are in a revmap page? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: