Re: PoC: using sampling to estimate joins / complex conditions

2022-03-21 Thread Tomas Vondra
On 3/22/22 00:35, Andres Freund wrote: > Hi, > > On 2022-01-21 01:06:37 +0100, Tomas Vondra wrote: >> Yeah, I haven't updated some of the test output because some of those >> changes are a bit wrong (and I think that's fine for a PoC patch). I >> should have mentioned that in the message, thoug

Re: PoC: using sampling to estimate joins / complex conditions

2022-03-21 Thread Andres Freund
Hi, On 2022-01-21 01:06:37 +0100, Tomas Vondra wrote: > Yeah, I haven't updated some of the test output because some of those > changes are a bit wrong (and I think that's fine for a PoC patch). I > should have mentioned that in the message, though. Sorry about that. Given that the patch hasn't b

Re: PoC: using sampling to estimate joins / complex conditions

2022-01-20 Thread Tomas Vondra
On 1/5/22 00:58, Andres Freund wrote: > Hi, > > On 2021-06-27 19:55:24 +0200, Tomas Vondra wrote: >> estimating joins is one of the significant gaps related to extended >> statistics, and I've been regularly asked about what we might do about >> that. This is an early experimental patch that I thi

Re: PoC: using sampling to estimate joins / complex conditions

2022-01-04 Thread Andres Freund
Hi, On 2021-06-27 19:55:24 +0200, Tomas Vondra wrote: > estimating joins is one of the significant gaps related to extended > statistics, and I've been regularly asked about what we might do about > that. This is an early experimental patch that I think might help us > with improving this, possibl

Re: PoC: using sampling to estimate joins / complex conditions

2021-12-02 Thread Michael Paquier
On Sun, Jun 27, 2021 at 07:55:24PM +0200, Tomas Vondra wrote: > estimating joins is one of the significant gaps related to extended > statistics, and I've been regularly asked about what we might do about > that. This is an early experimental patch that I think might help us > with improving this,

PoC: using sampling to estimate joins / complex conditions

2021-06-27 Thread Tomas Vondra
Hi, estimating joins is one of the significant gaps related to extended statistics, and I've been regularly asked about what we might do about that. This is an early experimental patch that I think might help us with improving this, possible even in PG15. Note: I do not claim this is exactly how