Re: [PERFORM] Rowcount estimation changes based on from clause order

2017-10-12 Thread Ants Aasma
On Thu, Oct 12, 2017 at 11:50 PM, Tom Lane wrote: > Ants Aasma writes: >> I stumbled upon a severe row count underestimation that confusingly >> went away when two inner joins in the from clause were reordered. > > Hm, looks more like an overestimate in this example, but anyway ... > >> Does anyb

Re: [PERFORM] Rowcount estimation changes based on from clause order

2017-10-12 Thread Tom Lane
Ants Aasma writes: > I stumbled upon a severe row count underestimation that confusingly > went away when two inner joins in the from clause were reordered. Hm, looks more like an overestimate in this example, but anyway ... > Does anybody have any idea what is going on here? set_joinrel_size_e