Pallav Kalva <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to