Re: Poor query plan across OR operator

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Mark Hills <Mark(dot)Hills(at)framestore(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor query plan across OR operator
Date: 2010-01-26 16:10:36
Message-ID: 2f4958ff1001260810y1571cb29y3f5fc625999e2715@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

just create index on both columns:
CREATE INDEX foo_i ON foo(bar1, bar2);

HTH

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-01-26 16:41:54 Re: Poor query plan across OR operator
Previous Message Mark Hills 2010-01-26 16:00:40 Poor query plan across OR operator