Re: PATCH: add support for IN and @> in functional-dependency statistics use
Daniel Gustafsson <daniel@yesql.se>
From: Daniel Gustafsson <daniel@yesql.se>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>,
Pierre Ducroquet <p.psql@pinaraf.info>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-07-01T08:47:46Z
Lists: pgsql-hackers
> On 29 Mar 2020, at 17:27, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote: > On Sun, Mar 29, 2020 at 10:22:25AM +0100, Dean Rasheed wrote: >> On Sat, 28 Mar 2020 at 13:18, Dean Rasheed <dean.a.rasheed@gmail.com> wrote: >>> OK, I've pushed that with your recommendation for that function name. >> >> Does this now complete everything that you wanted to do for functional >> dependency stats for PG13? Re-reading the thread, I couldn't see >> anything else that needed looking at. If that's the case, the CF entry >> can be closed. > > Yes. There were two improvements proposed, we've committed one of them > (the IN/ANY operator handling) and the other (containment) needs more > discussion. So I think it's OK to mark this either as committed or maybe > returned with feedback. Since there hasn't been more discussion on the second item I've closed this item as committed. The containment part can be opened as a new CF entry. cheers ./daniel
Commits
-
Prevent functional dependency estimates from exceeding column estimates.
- 87779aa47463 13.0 landed
-
Recognize some OR clauses as compatible with functional dependencies
- ccaa3569f587 13.0 landed
-
Use multi-variate MCV lists to estimate ScalarArrayOpExpr
- e83daa7e331e 13.0 landed
-
Use functional dependencies to estimate ScalarArrayOpExpr
- 8f321bd16cdb 13.0 landed