Re: Regarding Plan tree output(Index/Bitmap Scan)

2023-04-11 Thread Justin Pryzby
On Tue, Apr 11, 2023 at 06:09:41PM -0700, Ajay P S wrote: > I am trying to understand the Plan tree for select queries. Can you > please help me with the below queries? > > 1) Why is there a difference in plan tree for these two queries? User > table tidx1 has an index on column 'a' . Based on th

Regarding Plan tree output(Index/Bitmap Scan)

2023-04-11 Thread Ajay P S
Hi, I am trying to understand the Plan tree for select queries. Can you please help me with the below queries? 1) Why is there a difference in plan tree for these two queries? User table tidx1 has an index on column 'a' . 2) Why do we do Index scan and not Bitmap Index Scan for catalog tables?