Tom Lane <tgl@xxxxxxxxxxxxx> 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
