[HACKERS] Deciding which index to use

2014-11-11 Thread Christophe Pettus
Where in the optimizer code does PostgreSQL decide which of several possibly-matching partial indexes to use? -- -- Christophe Pettus x...@thebuild.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Deciding which index to use

2014-11-11 Thread Tom Lane
Christophe Pettus x...@thebuild.com writes: Where in the optimizer code does PostgreSQL decide which of several possibly-matching partial indexes to use? It costs them all out and uses the cheapest. If the cost estimates come out exactly the same, you get an arbitrary choice (I think probably