John A Meinel <[EMAIL PROTECTED]> writes: > I am a little surprised that it is taking 40s to scan only 400k rows, > though.
Yeah, that seemed high to me too. Table bloat maybe? It would be interesting to look at the output of "vacuum verbose test" to see how much dead space there is. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq