On mán, 2007-03-26 at 20:33 +0530, Gauri Kanekar wrote:
you did not show your query, nor did you answer whather you had vacuumed
and analyzed.
> enable_seqscan = off
why this? this is unlikely to help
>
> QUERY PLAN
> ...
> -> Nested Loop
> (cost=0.00..1104714.83 rows=6801 width=44) (actual
> time=1820.153..229779.814 rows=10945938 loops=1)
the estimates are way off here. you sure you have analyzed?
gnari
>