Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence scan if "OR Condition" in where statement - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Sequence scan if "OR Condition" in where statement
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207DECB73@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Sequence scan if "OR Condition" in where statement  (Prashant Bharucha <prashantbharucha@yahoo.ca>)
List pgsql-general
Tree view 
Prashant Bharucha wrote:
> Could you please help me , index is not using if have "OR condition in
where statement" ?
>
> Always have sequence scan.

You need to provide more details, see
http://wiki.postgresql.org/wiki/SlowQueryQuestions
to get an idea.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: Question about schema-level permissions
Next
From: Evan Martin
Date:
Subject: Why is RELEASE SAVEPOINT sometimes slow?