[HACKERS] Re: Idea for reducing planning time

2000-12-15 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > My quick question is that if we have a1=b1 and b1=c1, isn't the join > sorted by a1, b1, and c1, and threfore we don't get more sorted plans? That's not the issue. See, before the transitive-equality patch, if you wrote select * from a,b,c whe

[HACKERS] Re: Idea for reducing planning time

2000-12-15 Thread Bruce Momjian
> What I'm thinking of doing is truncating the recorded pathkeys of a path > at the first sortkey that's not useful for either a higher-level > mergejoin clause or the requested final output sort ordering. Then the > logic inside add_path() wouldn't change, but it would only be considering > usef