Re: why my query is not using index??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: HyunSung Jang <siche(at)siche(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: why my query is not using index??
Date: 2004-10-11 14:26:08
Message-ID: 5032.1097504768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

HyunSung Jang <siche(at)siche(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alban Médici (NetCentrex) 2004-10-11 15:39:01 Re: [PERFORM] stats on cursor and query execution
Previous Message Tom Lane 2004-10-11 14:22:03 Re: COPY slows down?