Postgres Pro
Downloads
Home   >   mailing lists

Re: Add support for (Var op Var) clause in extended MCV statistics - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: Add support for (Var op Var) clause in extended MCV statistics
Date
Msg-id 4d00d95d-1edf-44fb-8f58-5149fec5a418@tantorlabs.com
Whole thread Raw
In response to Add support for (Var op Var) clause in extended MCV statistics  (Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>)
List pgsql-hackers
Tree view 
Another issue mentioned in [1] involves cases where the clause is in the 
form (A op A). In my view, this isn't related to the current patch, as 
it can be addressed by rewriting the clause, similar to transforming A = 
A into A IS NOT NULL. This adjustment would result in more accurate 
estimation.

[1]: 
https://www.postgresql.org/message-id/7C0F91B5-8A43-428B-8D31-556458720305%40enterprisedb.com

Ilia Evdokimov,
Tantor Labs LLC.

pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: PostgreSQL's approach to assertion usage: seeking best practices
Next
From: Michail Nikolaev
Date:
Subject: Re: [BUG?] check_exclusion_or_unique_constraint false negative