Thanks for response, sir.
On 11/20/2016 1:18 AM, Tom Lane wrote:
Man Trieu writes:
As in the example below, i think the plan which hash table is created on
testtbl2 (the fewer tuples) should be choosen.
The planner usually prefers to hash on the table that has a flatter
MCV histogram, since
Thanks for reply, sir.
On 11/21/2016 1:39 AM, Tom Lane wrote:
Man writes:
Additional information.
In 9.6 the second table (lesser tuple) was choosen (the same testdata).
There are something (cost estimation?) different in previous versions.
I'd bet on different statistics in th
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
2017-06-07 0:31 GMT+09:00 Bruce Momjian :
> On Wed, Jun 7, 2017 at 12:10:25AM +0900, Dang Minh Huong wrote:
> > > On Jun 4, 29 Heisei, at 00:48, Bruce Momjian wrote:
> > Shouldn't you use "or is_letter_with_marks()", instead of "or
> len(...)
> > > 1"? Your test might catch something t
