"Joel Fradkin" <[EMAIL PROTECTED]> writes: > random_page_cost = 1.2#4 # units are one sequential page > fetch cost
That is almost certainly overoptimistic; it's causing the planner to use indexscans when it shouldn't. Try 2 or 3 or thereabouts. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster