Postgres Pro
Downloads
Home   >   mailing lists

Re: AND OR combination: index not being used - Mailing list pgsql-performance

From Tom Lane
Subject Re: AND OR combination: index not being used
Date
Msg-id 254.1115907326@sss.pgh.pa.us
Whole thread Raw
In response to AND OR combination: index not being used  (David Teran <david.teran@cluster9.com>)
Responses Re: AND OR combination: index not being used
List pgsql-performance
Tree view 
David Teran <david.teran@cluster9.com> writes:
> Any hint how
> to force postgres to use the index even with more OR parts?

More up-to-date statistics would evidently help; the thing is estimating
hundreds of rows returned and actually finding none.

            regards, tom lane

pgsql-performance by date:

Previous
From: Alex Turner
Date:
Subject: Re: Partitioning / Clustering
Next
From: Tom Lane
Date:
Subject: Re: tuning Postgres for large data import (using Copy from)