Re: Understanding sequential versus index scans. - Mailing list pgsql-general

From John R Pierce
Subject Re: Understanding sequential versus index scans.
Date
Msg-id 4A63B0B7.4030109@hogranch.com
Whole thread Raw
In response to Understanding sequential versus index scans.  (Robert James <srobertjames@gmail.com>)
List pgsql-general
Robert James wrote:
> Hi.  I notice that when I do a WHERE x, Postgres uses an index, and
> when I do WHERE y, it does so as well, but when I do WHERE x OR y, it
> doesn't.  Why is this so? And how can I shut this off?

maybe its because you have no index on (X OR Y) ?  or maybe because the
analyzer thinks that X or Y includes enough rows that a sequential scan
is more effective ?





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Understanding sequential versus index scans.
Next
From: Dennis Gearon
Date:
Subject: Re: timestamp with time zone tutorial