Re: Use of additional index columns in rows filtering
От | Jeff Davis |
---|---|
Тема | Re: Use of additional index columns in rows filtering |
Дата | |
Msg-id | 381794e81626fbd9f9c79dd43109faf91093fb97.camel@j-davis.com обсуждение исходный текст |
Ответ на | Re: Use of additional index columns in rows filtering (Tomas Vondra <tomas.vondra@enterprisedb.com>) |
Ответы |
Re: Use of additional index columns in rows filtering
|
Список | pgsql-hackers |
On Wed, 2023-07-19 at 11:16 +0200, Tomas Vondra wrote: > I wonder if Andres was right (in the index prefetch thread) that > splitting regular index scans and index-only scans may not be ideal. > In > a way, this patch moves those nodes closer, both in capability and > code > (because now both use index_getnext_tid etc.). Yeah. I could also imagine decomposing the index scan node into more pieces, but I don't think it would work out to be a clean data flow. Either way, probably out of scope for this patch. For this patch I think we should just tweak the EXPLAIN output so that it's a little more clear what parts are index-only (at least if VM bit is set) and what parts need to go to the heap. Regards, Jeff Davis
В списке pgsql-hackers по дате отправления: