Re: [HACKERS] pass-through queries to foreign servers

2013-08-10 Thread David Gudeman
On Mon, Aug 5, 2013 at 12:21 PM, Tom Lane t...@sss.pgh.pa.us wrote: David Gudeman dave.gude...@gmail.com writes: For those who don't want to go to the link to see what I'm talking about with query rewrites, I thought I'd give a brief description. Foreign data wrappers currently do all

Re: [HACKERS] pass-through queries to foreign servers

2013-08-05 Thread David Gudeman
-through query has to be available in Postgresql SQL. My current implementation of this uses a plugin that hooks into planner_hook, but I'm hoping that I can get some support for adding the query rewriting as callback functions for the FDW system. Regards, David Gudeman http

Re: [HACKERS] pass-through queries to foreign servers

2013-08-01 Thread David Gudeman
On Tue, Jul 30, 2013 at 10:22 PM, Tom Lane t...@sss.pgh.pa.us wrote: David Fetter da...@fetter.org writes: On Tue, Jul 30, 2013 at 04:40:38PM -0700, David Gudeman wrote: When you write an application involving foreign tables, you frequently end up with queries that are just too inefficient

[HACKERS] pass-through queries to foreign servers

2013-07-30 Thread David Gudeman
. But this probably requires less work for the authors of foreign data wrappers and it doesn't materialize the results of the foreign query unnecessarily. Any suggestions or hints? Regards, David Gudeman http://unobtainabol.blogspot.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] minimizing the target list for foreign data wrappers

2013-04-23 Thread David Gudeman
mature enough for what I need to do. Regards, David Gudeman On Mon, Apr 22, 2013 at 11:27 AM, David Gudeman dave.gude...@gmail.com wrote: Re-reading my first email I thought it was a little confusing, so here is some clarification. In GetForeignPlan, tlist seems to be a target list for a basic

[HACKERS] a patch for row-at-a-time execution for table functions

2013-04-23 Thread David Gudeman
The primary change we made to Postgres in order to support our own version of foreign data wrappers was a row-at-a-time execution for table functions. In standard Postgres, when you execute a table function, it gathers all of the rows at once and stuffs them into a buffer in order to support

Re: [HACKERS] minimizing the target list for foreign data wrappers

2013-04-22 Thread David Gudeman
? Thanks. On Sun, Apr 21, 2013 at 6:57 PM, David Gudeman dave.gude...@gmail.com wrote: A few years ago I wrote a roll-your-own foreign-data-wrapper system for Postgres because Postgres didn't have one at the time (some details here (http://unobtainabol.blogspot.com/2013/04/dave-foreign-data

[HACKERS] minimizing the target list for foreign data wrappers

2013-04-21 Thread David Gudeman
and testing it only to find that I'm making some bogus assumptions. Thanks, David Gudeman