K C Lau <[EMAIL PROTECTED]> writes: > At 20:48 05/09/22, Simon Riggs wrote: >> Even if this were fixed for 8.1, which seems unlikely, would you be able >> to move to that release immediately?
> Yes. In fact when we first developed our system a few years ago, we tested > on MS7.0, Oracle 8 and PG 7.1.1 and we did not hit that problem. It's really not credible that PG 7.1 did any better with this than current sources do. The subplan mechanism hasn't changed materially since about 6.5. It could be that 7.1's performance was simply so bad across the board that you didn't notice ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly