Content-Type: multipart/alternative;
 boundary="------------Ezatr2OixZmES7wo7feMRxqw"
Message-ID: <d3206a3d-830a-4a0a-a0c7-5c2a88205f33@postgrespro.ru>
Date: Mon, 12 Feb 2024 11:50:34 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Add semi-join pushdown to postgres_fdw
Content-Language: en-US, ru-RU
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Alexander Pyhalov <a.pyhalov@postgrespro.ru>,
 Tomas Vondra <tomas.vondra@enterprisedb.com>,
 "Fujii.Yuki@df.MitsubishiElectric.co.jp"
 <Fujii.Yuki@df.mitsubishielectric.co.jp>,
 Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>,
 Pgsql Hackers <pgsql-hackers@postgresql.org>,
 Ian Lawrence Barwick <barwick@gmail.com>
References: <c9e2a757cf3ac2333714eaf83a9cc184@postgrespro.ru>
 <10b3408a0880462d2ec6e3a92a46800a@postgrespro.ru>
 <CAB8KJ=hXB8=JfFM5e+UTkEDTNU0gA8Xr-nToMNGahZc7ktD-gA@mail.gmail.com>
 <81d8befc64cfd7ccc4a3f3e5c6862f20@postgrespro.ru>
 <OS3PR01MB6660A7F36A2D37194DB601F195169@OS3PR01MB6660.jpnprd01.prod.outlook.com>
 <816fa8b1bc2da09a87484d1ef239a332@postgrespro.ru>
 <4d6b5ec7-1583-f253-c6d2-810602b4b2aa@enterprisedb.com>
 <f929c315c6f3e9114ffc53e29fe83689@postgrespro.ru>
 <CAPpHfdtLSp3YnmbTMpUZvBa=kJ3qLosUQVjNfW3__=oWUP8dkg@mail.gmail.com>
 <3dd9320e01232eb931b747ed75a26cfb@postgrespro.ru>
 <CAPpHfdtYndP0+P4YjJrNAgX6X6xVL6z4n0L_u3P=se+Xt0VksA@mail.gmail.com>
 <f76e5ec21f827bcc4ceca4b398ba7289@postgrespro.ru>
 <CAPpHfdsbqy93Og9_0UrtNmCxE7LRwLWLTrmeHkOfeWtvg5tSAA@mail.gmail.com>
 <b333e7556b6c75400ec3176fcf3a4665@postgrespro.ru>
 <334dfcc5-51a1-4f0e-a8b8-6f8263d140a1@postgrespro.ru>
 <CAPpHfdsgBv+O9NL6sE=ifJY=6uvdbLLgknPp9UqwELAiDjjPwQ@mail.gmail.com>
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
In-Reply-To: <CAPpHfdsgBv+O9NL6sE=ifJY=6uvdbLLgknPp9UqwELAiDjjPwQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/d3206a3d-830a-4a0a-a0c7-5c2a88205f33%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Ezatr2OixZmES7wo7feMRxqw
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi, Alexander!

On 12.02.2024 05:27, Alexander Korotkov wrote:
>> But the worst thing is that replacing AND with OR causes breaking session and server restart:
> I haven't managed to reproduce this yet.  Could you give more details:
> machine, OS, compile options, backtrace?

We already had off-list conversation with Alexander Pyhalov.

Yesterday, after rebuilding the server, I can't reproduce the error.
I have good reason to believe that the problem was on my side.
On Friday, I tested another patch and built the server several times.
Most likely, I just made a mistake during the server build.

Sorry for the noise.

-- 
Pavel Luzanov
Postgres Professional:https://postgrespro.com

--------------Ezatr2OixZmES7wo7feMRxqw
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Hi, Alexander!<br>
    <br>
    <div class="moz-cite-prefix">On 12.02.2024 05:27, Alexander Korotkov
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAPpHfdsgBv+O9NL6sE=ifJY=6uvdbLLgknPp9UqwELAiDjjPwQ@mail.gmail.com"><span
      style="white-space: pre-wrap">
</span><span style="white-space: pre-wrap">
</span>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">But the worst thing is that replacing AND with OR causes breaking session and server restart:
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
I haven't managed to reproduce this yet.  Could you give more details:
machine, OS, compile options, backtrace?</pre>
    </blockquote>
    <pre>We already had off-list conversation with Alexander Pyhalov.

Yesterday, after rebuilding the server, I can't reproduce the error.
I have good reason to believe that the problem was on my side.
On Friday, I tested another patch and built the server several times.
Most likely, I just made a mistake during the server build.

Sorry for the noise.
</pre>
    <pre class="moz-signature" cols="72">-- 
Pavel Luzanov
Postgres Professional: <a class="moz-txt-link-freetext" href="https://postgrespro.com">https://postgrespro.com</a></pre>
  </body>
</html>

--------------Ezatr2OixZmES7wo7feMRxqw--