Re:Understanding Postgres Performance
by cafard on Tuesday October 02, 2012 @04:35PM
(#4604107)
The problem you can run into, and this will depend on the state of your optimizer, is that you may have a join, and the presence of the index may give you a nested-loops path when a hash join would be more efficient.
[ Parent
| on HN ]