Indexes and OR clauses. - Mailing list pgsql-hackers

From Keith Parks
Subject Indexes and OR clauses.
Date
Msg-id 199802132345.XAA27580@mtcc.demon.co.uk
Whole thread Raw
List pgsql-hackers
Hi All,

I know I'm not capable of locating or fixing the problem with
this so it's a it of a cheek asking but...

Is it time to increase the priority of the TODO item:-

* Allow indexes to be used with OR clauses

This would seem particularly important with the new subselect
functionality. (Great work vadim)

Many subselect-using queries use the "IN" keyword which we
translate to a string of "OR"s so could potentially benefit
from index useage.

Keith.


pgsql-hackers by date:

Previous
From: al dev
Date:
Subject: performace speed up suggestions.
Next
From: Ryan Kirkpatrick
Date:
Subject: Re: [HACKERS] PostGreSQL v6.2.1 for Linux Alpha