Re: Single column vs composite partial index

2020-09-15 Thread Justin Pryzby
On Tue, Sep 15, 2020 at 10:33:24PM +, Nagaraj Raj wrote: > Hi, > I'm running one query, and I created two types of index one is composite and > the other one with single column one and query planner showing almost the > same cost for both index bitmap scan, I'm not sure which is appropriate t

Single column vs composite partial index

2020-09-15 Thread Nagaraj Raj
Hi, I'm running one query, and I created two types of index one is composite and the other one with single column one and query planner showing almost the same cost for both index bitmap scan, I'm not sure which is appropriate to keep in production tables. explain analyze SELECT BAN, SUBSCRIBER