Eric Schwarzenbach <subscriber@blackbrook.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