From: | Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | postgres_fdw: evaluate placeholdervars on remote server |
Date: | 2017-02-28 12:45:22 |
Message-ID: | 6533e100-dbdf-1ac3-23f3-6ca9da48adbb@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
Here is a patch for $subject. This is the same as what I proposed in
combination with a feature for full joins [1]; this would allow us to
push down left/right/full joins with PHVs to the remote and improve how
to deparse whole-row references. Since this is implemented on top of
the feature for full-joins (ie, the deparser logic for subqueries), I
proposed this on that thread, but this is slightly independent from that
feature (and we haven't discussed this in detail on that thread), so I
think it's better to start new thread. Attached is a new version, which
is created on top of [2]. I'll add this to the upcoming CF.
Best regards,
Etsuro Fujita
[1]
https://www.postgresql.org/message-id/c449261a-b033-dc02-9254-2fe5b7044795%40lab.ntt.co.jp
[2]
https://www.postgresql.org/message-id/920e660b-6fec-6022-759d-e96e37dd5984%40lab.ntt.co.jp
Attachment | Content-Type | Size |
---|---|---|
postgres-fdw-eval-phvs-remotely-1.patch | text/x-diff | 73.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-02-28 13:05:16 | Re: avoid bloat from CREATE INDEX CONCURRENTLY |
Previous Message | Alvaro Herrera | 2017-02-28 12:39:03 | Re: timeouts in PostgresNode::psql |