Postgres Pro
Downloads
Home   >   mailing lists

Re: why my query is not using index?? - Mailing list pgsql-performance

From Tom Lane
Subject Re: why my query is not using index??
Date
Msg-id 5032.1097504768@sss.pgh.pa.us
Whole thread Raw
In response to why my query is not using index??  (HyunSung Jang <siche@siche.net>)
List pgsql-performance
Tree view 
HyunSung Jang <siche@siche.net> writes:
> can you explain to me why it's not doing that i expected??

Have you ANALYZEd this table recently?  The estimated row counts seem
way off.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY slows down?
Next
From: "Alban Médici (NetCentrex)"
Date:
Subject: Re: [pgsql-benchmarks] stats on cursor and query execution