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

From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To: Tomas Vondra <tomas(at)vondra(dot)me>, Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add support for (Var op Var) clause in extended MCV statistics
Date: 2024-09-09 10:43:02
Message-ID: 65f19ede-8294-47de-b1a1-038b45e33c79@tantorlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi everyone,

I've taken a closer look at the patch and realized that we don't need
the new function 'mcv_clause_selectivity_var_op_var()' we can use
'mcv_clause_selectivity()' instead.

I'm attaching the updated patch and test generator.

--
Regards,
Ilia Evdokimov,
Tantor Labs LCC.

Attachment Content-Type Size
test_generator.py text/x-python 4.2 KB
v4-0001-Add-support-for-Var-op-Var-clause-in-extended-MCV.patch text/x-patch 46.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2024-09-09 10:54:09 Re: Add contrib/pg_logicalsnapinspect
Previous Message Alexander Korotkov 2024-09-09 10:36:54 Re: POC, WIP: OR-clause support for indexes