I am searching for some logic behind the selection of an index in
postgres -- it seems that if I have a composite index based on both
columns in a join table, it's only referenced if I query on the first
term in the composite index. I've read
On Mon, May 21, 2012 at 3:34 PM, Bill Mitchell b...@publicrelay.com wrote:
I am searching for some logic behind the selection of an index in
postgres -- it seems that if I have a composite index based on both columns
in a join table, it's only referenced if I query on the first term in the
On Mon, May 21, 2012 at 2:34 PM, Bill Mitchell b...@publicrelay.com wrote:
I am searching for some logic behind the selection of an index in postgres
-- it seems that if I have a composite index based on both columns in a join
table, it's only referenced if I query on the first term in the
2012/5/22 Merlin Moncure mmonc...@gmail.com
On Mon, May 21, 2012 at 2:34 PM, Bill Mitchell b...@publicrelay.com
wrote:
I am searching for some logic behind the selection of an index in
postgres
-- it seems that if I have a composite index based on both columns in a
join
table, it's only
On Mon, May 21, 2012 at 3:36 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
So you can get fully index lookups on all of a, b, ab, and ba. the
primary key can't optimize ba because indexes only fully match if
candidate fields are supplied from left to right order. They can
still help
Thanks to everybody's input -- as a first-time poster to this listserv,
I wasn't sure how long it would take to get a response. ;)
I was frankly astonished to see that the composite index on (a,b) was
used when I searched for (a), but Chris' response makes total sense.
In this case, I don't want