Karl Wright <[EMAIL PROTECTED]> writes: > I did an ANALYZE on that table and repeated the explain, and got this: > ... > ... even more wildly wrong.
Hmm. You might need to increase the statistics target for your larger tables. It's probably not a big deal for queries like this one, but I'm worried that you may be getting bad plans for complicated joins. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match