| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Russ Brown" <postgres(at)dot4dot(dot)plus(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Join efficiency |
| Date: | 2004-09-01 14:31:07 |
| Message-ID: | 6366.1094049067@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Russ Brown" <postgres(at)dot4dot(dot)plus(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2004-09-01 14:35:01 | pg_autovacuum (7.4) nss_ldap oddity |
| Previous Message | Greg Donald | 2004-09-01 14:24:09 | <> syntax legal? |