Re: Planning performance problem (67626.278ms)

2021-06-29 Thread Tom Lane
Manuel Weitzman writes: > On 29-06-2021, at 15:43, Tom Lane wrote: >> That seems a bit broken; a given WHERE clause should produce only one >> RestrictInfo. Can you provide a more concrete example? >> explain (analyze, buffers) >> select * from a >> join b b1 on (b1.a = a.a) >> join b b2 on (b2

Re: Planning performance problem (67626.278ms)

2021-06-29 Thread Manuel Weitzman
> On 29-06-2021, at 15:43, Tom Lane wrote: > > Manuel Weitzman writes: >>> On 20-06-2021, at 17:06, Tom Lane wrote: >>> So ... the reason why there's not caching of get_actual_variable_range >>> results already is that I'd supposed it wouldn't be necessary given >>> the caching of selectivity

Re: Planning performance problem (67626.278ms)

2021-06-29 Thread Tom Lane
Manuel Weitzman writes: >> On 20-06-2021, at 17:06, Tom Lane wrote: >> So ... the reason why there's not caching of get_actual_variable_range >> results already is that I'd supposed it wouldn't be necessary given >> the caching of selectivity estimates that happens at the RestrictInfo >> level.

Re: Planning performance problem (67626.278ms)

2021-06-29 Thread Manuel Weitzman
> On 20-06-2021, at 17:06, Tom Lane wrote: > > So ... the reason why there's not caching of get_actual_variable_range > results already is that I'd supposed it wouldn't be necessary given > the caching of selectivity estimates that happens at the RestrictInfo > level. I don't have any objectio