| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Jodi Kanter <jkanter(at)virginia(dot)edu>, Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: indexes not being used! |
| Date: | 2003-03-21 16:02:30 |
| Message-ID: | 13300.1048262550@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Joe Conway <mail(at)joeconway(dot)com> writes:
> It's hard to tell from what you did post, but if the query returns a
> significant portion of the table then a seq scan is faster, and is
> properly picked by the optimizer. Please post EXPLAIN ANALYZE results.
And do a VACUUM ANALYZE beforehand. The explain estimates look like
the planner thinks all these tables are tiny.
> (and actually, this thread probably should be on the SQL or the PERFORM
> lists, not this one)
Right.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jodi Kanter | 2003-03-21 16:07:23 | Re: indexes not being used! |
| Previous Message | Andreas Schmitz | 2003-03-21 15:47:46 | Re: indexes not being used! |