Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> While I don't have any very strong objection to putting an ORDER BY >> on these particular queries, I'm worried about how many other regression >> tests will now start showing random failures. We have an awful lot >> of small tables in the tests ...
> Maybe what we could do is set higher thresholds for the regression > database with ALTER DATABASE. That seems to make sense at least as a short-term response. We weren't seeing buildfarm failures with the previous defaults, so setting those values with ALTER oughta do it. 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