From: | "Michael Paesold" <mpaesold(at)gmx(dot)at> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org>, "Russ Brown" <postgres(at)dot4dot(dot)plus(dot)com> |
Subject: | Re: Join efficiency |
Date: | 2004-09-01 14:21:31 |
Message-ID: | 018a01c4902e$fc6158b0$ad01a8c0@zaphod |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Russ Brown wrote:
> >> SELECT * FROM a, b WHERE a.x=b.x;
> >> SELECT * FROM a JOIN b ON a.x=b.x;
> That being the case, would it be true to say that with recent versions of
> PostgreSQL they both perform identically, meaning the second could be
> considered preferable due to its self-documenting nature (and consistency
> with the OUTER JOIN syntax)?
Assuming join_collapse_limit is at it's default or set higher...
As far as I can say from reading the documentation, following the hackers
list and trying out myself: yes, both versions should yield the same
optimized query plan and are therefore equal performance wise.
You can just use the one you prefer.
Best Regards,
Michael Paesold
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Donald | 2004-09-01 14:24:09 | <> syntax legal? |
Previous Message | Richard Huxton | 2004-09-01 12:58:13 | Re: Join efficiency |