K C Lau <kclau60@netvigator.com> 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