On Thu, Sep 10, 2009 at 10:02 AM, Robert Haas <[email protected]> wrote:
> On Thu, Sep 10, 2009 at 12:56 PM, bricklen <[email protected]> wrote: > > On Thu, Sep 10, 2009 at 8:43 AM, Tom Lane <[email protected]> wrote: > >> > >> bricklen <[email protected]> writes: > >> > Is there any other data I can provide to shed some light on this? > >> > >> The table and index definitions? > >> > >> The straight indexscan would probably win if the index column order > >> were ofid, date instead of date, ofid. I can't tell if you have > >> any other queries for which the existing column order is preferable, > >> though. > >> > >> regards, tom lane > > > > > > Changing the order of the WHERE predicates didn't help. > > He's talking about the index definition, not the WHERE clause. The > order of the WHERE clause is totally irrelevant. > > Ah, sorry, missed that.
