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%. This is using Postgres 8.3 on a database with GEQO turned off. Is this what would be expected? Does the query planner / optimizer generally do better with explicit JOIN syntax? Cheers, Eric -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
