Re: [GENERAL] How to change order sort of table in HashJoin

2016-11-19 Thread Melvin Davidson
On Sat, Nov 19, 2016 at 12:46 AM, Man Trieu wrote: > Hi Experts, > > As in the example below, i think the plan which hash table is created on > testtbl2 (the fewer tuples) should be choosen. > Because creating of hash table should faster in testtbl2. But it did not. > > I have tried to change the

[GENERAL] How to change order sort of table in HashJoin

2016-11-18 Thread Man Trieu
Hi Experts, As in the example below, i think the plan which hash table is created on testtbl2 (the fewer tuples) should be choosen. Because creating of hash table should faster in testtbl2. But it did not. I have tried to change the ordering of table by tuning parameter even if using pg_hint_plan