query plan and parenthesis - Mailing list pgsql-general

From Jan Poslusny
Subject query plan and parenthesis
Date
Msg-id 3EE99C49.8030001@gingerall.cz
Whole thread Raw
Responses Re: query plan and parenthesis  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,
I have following view definition given by '\d' command: SELECT t1.col1
FROM ((table1 t1 JOIN table2 t2 ON ((t1.id = t2.id))) JOIN table3 t3 ON
((t2.some = t3.some)));
Is query planner able to optimize order of joining (t1, t2), t3 or must
join with order described by parenthesis ? This is very important for
joining small (50 rows) and huge (5M rows) tables.


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Next
From: Justin Clift
Date:
Subject: Re: [pgsql-www] [Fwd: Advertising not appearing on PostgreSQL.org]