Re: Case expression pushdown

From: Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>
To: Seino Yuki <seinoyu(at)oss(dot)nttdata(dot)com>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Case expression pushdown
Date: 2021-06-22 13:39:43
Message-ID: 8da3ab3dc5b17c44d6f4f7687152128b@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Seino Yuki писал 2021-06-22 16:03:
> On 2021-06-16 01:29, Alexander Pyhalov wrote:
>> Hi.
>>
>> Ashutosh Bapat писал 2021-06-15 16:24:
>>> Looks quite useful to me. Can you please add this to the next
>>> commitfest?
>>>
>>
>> Addded to commitfest. Here is an updated patch version.
>
> Thanks for posting the patch.
> I agree with this content.
>
>> + Foreign Scan on public.ft2 (cost=156.58..165.45 rows=394 width=14)
> It's not a big issue, but is there any intention behind the pattern of
> outputting costs in regression tests?

Hi.

No, I don't think it makes much sense. Updated tests (also added case
with empty else).
--
Best regards,
Alexander Pyhalov,
Postgres Professional

Attachment Content-Type Size
0001-Allow-pushing-CASE-expression-to-foreign-server-v3.patch text/x-diff 12.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2021-06-22 14:21:19 Re: Cosmic ray hits integerset
Previous Message Tom Lane 2021-06-22 13:24:47 Re: subscription/t/010_truncate.pl failure on desmoxytes in REL_13_STABLE