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

2013-08-12 Thread Merlin Moncure
On Mon, Aug 5, 2013 at 2:02 PM, Pavel Stehule wrote: > Hello > > 2013/8/5 David Gudeman : >> 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 of their work in the plann

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

2013-08-11 Thread Ashutosh Bapat
On Tue, Aug 6, 2013 at 12:51 AM, Tom Lane wrote: > David Gudeman 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 of their work in the planning > > phas

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 wrote: > David Gudeman 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 of their work in the planning >> phase but

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

2013-08-05 Thread Tom Lane
David Gudeman 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 of their work in the planning > phase but I claim that isn't the right place to optimize foreign

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

2013-08-05 Thread Pavel Stehule
Hello 2013/8/5 David Gudeman : > 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 of their work in the planning > phase but I claim that isn't the right place to optimize

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

2013-08-05 Thread David Gudeman
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 of their work in the planning phase but I claim that isn't the right place to optimize foreign queries with aggregates and GRO

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 wrote: > David Fetter 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 because they bring >>> too mu

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

2013-07-31 Thread David Fetter
On Wed, Jul 31, 2013 at 01:22:56AM -0400, Tom Lane wrote: > David Fetter 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 because they bring

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

2013-07-30 Thread Tom Lane
David Fetter 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 because they bring >> too much data over from the foreign server. For a trivial examp

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

2013-07-30 Thread David Fetter
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 because they bring > too much data over from the foreign server. For a trivial example, > consider "SELECT coun

[HACKERS] pass-through queries to foreign servers

2013-07-30 Thread David Gudeman
When you write an application involving foreign tables, you frequently end up with queries that are just too inefficient because they bring too much data over from the foreign server. For a trivial example, consider "SELECT count(*) FROM t" where t is a foreign table. This will pull the entire tabl