From: | David Beck <dbeck(at)starschema(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: New hook after raw parsing, before analyze |
Date: | 2014-02-14 09:30:18 |
Message-ID: | 139EB8EC-9644-4424-B5E2-675375DD0323@starschema.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thanks for the reply. There are two things I think I’ve been misunderstood:
1, the point is to do the rewrite without and before catalog access
2, I do want to push the join to the source and equally important pushing the where conditions there
Best regards, David
2014.02.13. dátummal, 21:22 időpontban Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> írta:
> David Beck <dbeck(at)starschema(dot)net> writes:
>> I have table like data structures in the source system for the FDW I work on.
>> These tables are sometimes too big and the source system is able to filter and join them with limitations, thus it is not optimal to transfer the data to Postgres.
>> At the same time I want the users to think in terms of the original tables.
>
>> The idea is to rewrite the SQL queries like this:
>
>> “SELECT * FROM tableA a, tableB b WHERE a.id=b.id AND a.col1=1234 AND b.col2=987”
>
>> to:
>
>> “SELECT * FROM fdw_tableA_tableB ab WHERE ab.col1=1234 AND ab.col2=987”
>
> TBH this sounds like a spectacularly bad idea, especially in the place and
> way you propose to do it. You can't even do catalog access safely where
> you've put that hook, not to mention that there are many other places
> where queries can be submitted. But more generally, an FDW should not
> operate in the way you're describing.
>
> We do lack support for pushing joins to the foreign server, and that needs
> to be addressed; but we need to do it in the planner, not by kluging the
> query somewhere upstream of that.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Rijkers | 2014-02-14 09:42:46 | Re: Changeset Extraction v7.6 |
Previous Message | Andres Freund | 2014-02-14 09:13:37 | Re: Changeset Extraction v7.6 |