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:
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