Re: [HACKERS] EvalPlanQual behaves oddly for FDW queries involving system columns

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, ashutosh(dot)bapat(at)enterprisedb(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] EvalPlanQual behaves oddly for FDW queries involving system columns
Date: 2019-03-15 12:58:25
Message-ID: 5C8BA171.8050005@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

(2019/03/04 12:10), Etsuro Fujita wrote:
> (2019/03/02 3:57), Andres Freund wrote:
>> FWIW, I pushed the EPQ patch, doing this conversion blindly. It'd be
>> awesome if you'd check that it actually works...
>
> I'll start the work later this week. I think I can post an (initial)
> report on that next week, maybe.

Here is an updated version of the patch [1]. This version doesn't allow
pushing down joins to the remote if there is a possibility that EPQ will
be executed, but I think it would be useful to test the EPQ patch. I
haven't looked into the EPQ patch in detail yet, but I tested the patch
with the attached, and couldn't find any issues on the patch.

Best regards,
Etsuro Fujita

[1] https://www.postgresql.org/message-id/16016.1431455074%40sss.pgh.pa.us

Attachment Content-Type Size
postgres-fdw-late-locking-2.patch text/x-patch 26.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-03-15 13:35:32 Re: hyrax vs. RelationBuildPartitionDesc
Previous Message Chris Travers 2019-03-15 12:57:40 Re: Re: Re: [HACKERS] Custom compression methods