Home > mailing lists

Multiple Indexes - Mailing list pgsql-general

From	DAVID ROTH
Subject	Multiple Indexes
Date	July 6, 2022 19:06:52
Msg-id	2102230696.1462195.1657123612585@connect.xfinity.com Whole thread Raw
In response to	Re: lifetime of the old CTID (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses	Re: Multiple Indexes (David Rowley <dgrowleyml@gmail.com>)
List	pgsql-general

I understand the planner can use multiple indexes to get the best plan.
Can someone point me a paper that explains how this works.
Thanks

From: Ilya Anfimov
Date: 06 July 2022, 18:56:02
Subject: Re: lifetime of the old CTID

From: Aleksander Łukasz
Date: 06 July 2022, 19:33:08
Subject: Why does pg_statio_user_tables report heap_blks_hit after index only scan?