Vitaly,
 
> I am in the middle of going through them all, till now disabling the
> enable_mergejoin really helped.

In that case, your random_page_cost is probably too low.   Check the ratio of 
per-tuple times on index vs. seqscan seeks.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to