> No analyze for 7.1.3. > Just ran vacuum a few minutes before the query. No boost at all. Even > with SET enable_seqscan = 0 it still does a table scan.
Dann, I can attest to 7.2 having a much better planner and performance than 7.1 did. Can you upgrade? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster