Re: Add support for (Var op Var) clause in extended MCV statistics

From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add support for (Var op Var) clause in extended MCV statistics
Date: 2024-08-12 10:59:24
Message-ID: 4d00d95d-1edf-44fb-8f58-5149fec5a418@tantorlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michail Nikolaev 2024-08-12 11:11:26 Re: [BUG?] check_exclusion_or_unique_constraint false negative
Previous Message Aleksander Alekseev 2024-08-12 10:55:04 Re: PostgreSQL's approach to assertion usage: seeking best practices