Re: [GENERAL] How does PostgerSQL planner decide driving table

2014-10-06 Thread Emanuel Calvo
El 06/10/14 02:38, Shingo horiuchi escribió: > > Dear All, > > > > I have read about query tuning and attempt to check the impact of > > exchanging the driving table in Join condition. > > > > To test Simple Join condition, I prepared Two tables. > > One is the table for employees and another

[GENERAL] How does PostgerSQL planner decide driving table

2014-10-05 Thread Shingo horiuchi
Dear All, I have read about query tuning and attempt to check the impact of exchanging the driving table in Join condition. To test Simple Join condition, I prepared Two tables. One is the table for employees and another is the table for departments. Employees table has the foreign key whi