Re: Use extended statistics to estimate (Var op Var) clauses

[Mark Dilger]

> On Aug 11, 2021, at 3:48 PM, Mark Dilger <mark.dil...@enterprisedb.com> wrote:
> 
> I'm working on a correlated stats test as I write this.  I'll get back to you 
> when I have results.

Ok, the tests showed no statistically significant regressions.  All tests 
included the same sorts of whereclause expressions as used in the tests from 
yesterday's email.

The first test created loosely correlated data and found no significant row 
estimate improvements or regressions.

The second test of more tightly correlated data showed a row estimate 
improvement overall, with no class of whereclause showing an estimate 
regression.  I think the apparent regressions from yesterday were just 
statistical noise.

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company