| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Pallav Kalva <pkalva(at)deg(dot)cc> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query Tuning |
| Date: | 2004-10-08 16:42:56 |
| Message-ID: | 13657.1097253776@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Pallav Kalva <pkalva(at)deg(dot)cc> writes:
> I have a problem with the below query, when i do explain on the
> below query on my live database it doesnt use any index specified on the
> tables and does seq scan on the table which is 400k records. But if i
> copy the same table onto a different database on a different machine it
> uses all the indexes specified and query runs much quicker.
It looks to me like you've never vacuumed/analyzed the copy, and so you
get a different plan there. The fact that that plan is better than the
one made with statistics is unhappy making :-( ... but when you only
show us EXPLAIN output rather than EXPLAIN ANALYZE, it's impossible to
speculate about why. Also, what PG version is this?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pallav Kalva | 2004-10-08 17:29:22 | Re: Query Tuning |
| Previous Message | Pallav Kalva | 2004-10-08 14:49:12 | Query Tuning |