Re: Poor query plan across OR operator

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Mark Hills <Mark.Hills@xxxxxxxxxxxxxx>
Subject: Re: Poor query plan across OR operator
From: Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>
Date: Tue, 26 Jan 2010 16:10:36 +0000
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <alpine.LFD.2.01.1001261532460.29382@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <alpine.LFD.2.01.1001261532460.29382@xxxxxxxxxxxxxxxxxxxxxxxxx>

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


HTH

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

References:
- Poor query plan across OR operator
  - From: Mark Hills

Prev by Date: Poor query plan across OR operator
Next by Date: Re: Poor query plan across OR operator
Previous by thread: Poor query plan across OR operator
Next by thread: Re: Poor query plan across OR operator
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux