Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor query plan across OR operator - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Poor query plan across OR operator
Date
Msg-id 2f4958ff1001260810y1571cb29y3f5fc625999e2715@mail.gmail.com
Whole thread Raw
In response to Poor query plan across OR operator  (Mark Hills <Mark.Hills@framestore.com>)
List pgsql-performance
Tree view 
just create index on both columns:
CREATE INDEX foo_i ON foo(bar1, bar2);


HTH

pgsql-performance by date:

Previous
From: Mark Hills
Date:
Subject: Poor query plan across OR operator
Next
From: Tom Lane
Date:
Subject: Re: Poor query plan across OR operator