| From: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
|---|---|
| To: | Sean Johnston <sean(dot)johnston(at)edgeintelligence(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
| Date: | 2019-05-24 19:30:41 |
| Message-ID: | CAPmGK17gNEwu6Q2aNW1Hr3P5xE4=L_MGAMOLs4HXMuA6NPDgkw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Sat, May 25, 2019 at 2:19 AM Sean Johnston
<sean(dot)johnston(at)edgeintelligence(dot)com> wrote:
> Obviously this isn't mainstream postgres but just wondering if anyone has looked into issues with regards to pushing order/limit to remote nodes for fdw.
In PostgreSQL 12 Beta 1 released this week [1], we can push down ORDER
BY/LIMIT to the remote PostgreSQL server. Give it a try!
Best regards,
Etsuro Fujita
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2019-05-27 12:54:27 | BUG #15820: Commuting two column make a SubqueryScan node to appear in the plan |
| Previous Message | Tom Lane | 2019-05-24 17:59:01 | Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2019-05-24 19:31:09 | Re: Suppressing noise in successful check-world runs |
| Previous Message | Florian Weimer | 2019-05-24 18:56:08 | Generated columns and indexes |