| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Eric Schwarzenbach <subscriber(at)blackbrook(dot)org> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: explicit JOIN faster than implicit? |
| Date: | 2009-08-05 23:10:37 |
| Message-ID: | 2808.1249513837@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Eric Schwarzenbach <subscriber(at)blackbrook(dot)org> writes:
> I'm in the process taking a large SELECT statement which had been
> written using implicit join syntax (that is, just listing all the tables
> in the FROM clause, and listing join conditions in the WHERE clause) and
> rewriting it to use explicit JOIN syntax (they are all inner joins).
> This has sped up the query by 50%.
Are you getting the same plan both ways? Have you distinguished between
planning time and execution time? How many tables in the query, and how
does that relate to your join_collapse_limit setting?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2009-08-05 23:17:08 | Re: explicit JOIN faster than implicit? |
| Previous Message | Filip Rembiałkowski | 2009-08-05 23:04:23 | Re: PREPARE query with IN? |