Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Before (if memory serves) 8.1, the planner would only consider leading
> index columns as potential indexscan qualifiers. So given
>
> where a = 5 and c = 4;
>
> only the a = 5 clause would be used with the index. As of 8.1 it will
> consider using nonconsecutive index columns
Really? Is this the "skip scan" plan people were pining for? I missed when
that happened.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com