Message-ID: <e562286f-4442-6ea7-19d1-896c349e96e0@postgrespro.ru>
Date: Wed, 20 Sep 2023 15:06:35 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.15.1
Subject: Re: POC, WIP: OR-clause support for indexes
To: Peter Eisentraut <peter@eisentraut.org>
Cc: "Finnerty, Jim" <jfinnert@amazon.com>, Marcos Pegoraro
 <marcos@f10.com.br>, Andrey Lepikhov <a.lepikhov@postgrespro.ru>,
 pgsql-hackers@postgresql.org, teodor@sigaev.ru,
 Ranier Vilela <ranier.vf@gmail.com>,
 Tomas Vondra <tomas.vondra@enterprisedb.com>, Peter Geoghegan <pg@bowt.ie>
References: <567ED6CA.2040504@sigaev.ru>
 <9ea35f18-419d-efb7-b7c8-2e641a61f020@yandex.ru>
 <CAH2-Wzm-W7KYtMQ_3F1zU3Fg0zhRd-kASuOzNewXEWjR5kZrtg@mail.gmail.com>
 <08f5ff34-1497-2123-8701-461a299035c9@yandex.ru>
 <CAH2-WznHNTXQ=bX4Kc9hHebyXvR0a0CxH9OnirkP0ahgQAX7Aw@mail.gmail.com>
 <8d714510-af73-a908-99c8-fc14536f2669@yandex.ru>
 <CAH2-WzkNaPbBJ_yWDXzk5ESJZH62vi=+brHHQ2SrDrPXka1xYA@mail.gmail.com>
 <b301dce1-09fd-72b1-834a-527ca428db5e@yandex.ru>
 <CAH2-WzmG-+vvN6YEh4J_j3-Q1Yn=HRrjDrz2HDhttPcLVqN0rw@mail.gmail.com>
 <bf504287-c3ac-e492-c6ea-31be60b2c92f@yandex.ru>
 <CAH2-WzkmLg0JPXkZ75b+ha_wJGoJk3QyZ6aUjA0Ba11rdPwdgw@mail.gmail.com>
 <fa5f57e1-4051-93d8-5f54-f1e2f4587cc2@yandex.ru>
 <4bac271d-1700-db24-74ac-8414f2baf9fd@postgrespro.ru>
 <CAH2-Wzkp1RYWC4Lsh==ALNeOR=gQEtCMVbcFRLa-faMQe6YRPA@mail.gmail.com>
 <CAH2-Wz=rJOP_1niMTSN_=pzKXUu5tAGRYMGj6uC6Xx=XzkgdPg@mail.gmail.com>
 <d3db5422-bef3-8009-0f4c-5fdaea849184@postgrespro.ru>
 <a2941c7a-df4f-c4f3-bca2-2fcc450980f7@eisentraut.org>
Content-Language: en-US
From: "a.rybakina" <a.rybakina@postgrespro.ru>
In-Reply-To: <a2941c7a-df4f-c4f3-bca2-2fcc450980f7@eisentraut.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/e562286f-4442-6ea7-19d1-896c349e96e0%40postgrespro.ru>
Precedence: bulk

Hi!

When I sent the patch version to commitfest, I thought that the work on 
this topic was completed. Patch version and test results in [0].

But in the process of discussing this patch, we found out that there is 
another place where you can make a transformation, specifically, during 
the calculation of selectivity. I implemented the raw version [1], but 
unfortunately it didn't work in regression tests.

I'm sorry that I didn't write about the status earlier, I was very 
overwhelmed with tasks at work due to releases and preparations for the 
conference. I returned to the work of this patch, today or tomorrow I'll 
drop the version.


[0]

https://www.postgresql.org/message-id/4bac271d-1700-db24-74ac-8414f2baf9fd%40postgrespro.ru

https://www.postgresql.org/message-id/11403645-b342-c400-859e-47d0f41ec22a%40postgrespro.ru

[1] 
https://www.postgresql.org/message-id/b301dce1-09fd-72b1-834a-527ca428db5e%40yandex.ru

On 20.09.2023 12:37, Peter Eisentraut wrote:
> On 29.08.23 05:37, a.rybakina wrote:
>> Thank you for your interest in this problem and help, and I'm sorry 
>> that I didn't respond to this email for a long time. To be honest, I 
>> wanted to investigate the problems in more detail and already answer 
>> more clearly, but unfortunately I have not found anything more 
>> significant yet.
>
> What is the status of this patch?  It is registered in the commitfest. 
> It looks like a stalled research project?  The last posted patch 
> doesn't contain any description or tests, so it doesn't look very ready.
>