Re: Join efficiency - Mailing list pgsql-general

From Tom Lane
Subject Re: Join efficiency
Date
Msg-id 6366.1094049067@sss.pgh.pa.us
Whole thread Raw
In response to Join efficiency  ("Russ Brown" <postgres@dot4dot.plus.com>)
List pgsql-general
"Russ Brown" <postgres@dot4dot.plus.com> writes:
> Is there any difference between these queries in terms of the speed of
> planning or the quality of the plan untimately used?

http://www.postgresql.org/docs/7.4/static/explicit-joins.html
http://www.postgresql.org/docs/7.3/static/explicit-joins.html
http://www.postgresql.org/docs/7.2/static/explicit-joins.html
http://www.postgresql.org/docs/7.1/static/explicit-joins.html

depending on which version you are using.  (I think 7.1-7.3
are essentially alike, but 7.4 is not.)

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Donald
Date:
Subject: <> syntax legal?
Next
From: Oliver Elphick
Date:
Subject: pg_autovacuum (7.4) nss_ldap oddity