Re: eqjoinsel_semi still sucks ...

2023-06-28 Thread Tom Lane
Alena Rybakina writes: > On 23.06.2023 14:28, Andrey Lepikhov wrote: >> On 2/5/2012 20:34, Tom Lane wrote: >>> On reflection I think that the idea of clamping ndistinct beforehand is >>> just wrong, and what we ought to do instead is apply a multiplier to the >>> selectivity estimate afterwards.

Re: eqjoinsel_semi still sucks ...

2023-06-25 Thread Alena Rybakina
On 23.06.2023 14:28, Andrey Lepikhov wrote: On 2/5/2012 20:34, Tom Lane wrote: On reflection I think that the idea of clamping ndistinct beforehand is just wrong, and what we ought to do instead is apply a multiplier to the selectivity estimate afterwards.  In the case of a base rel we could jus

Re: eqjoinsel_semi still sucks ...

2023-06-23 Thread Andrey Lepikhov
On 2/5/2012 20:34, Tom Lane wrote: On reflection I think that the idea of clamping ndistinct beforehand is just wrong, and what we ought to do instead is apply a multiplier to the selectivity estimate afterwards. In the case of a base rel we could just multiply by the selectivity of its baserest