Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id CB7C41337990
	for <pgsql-students-postgresql.org@mail.postgresql.org>;
	Sat, 26 Mar 2011 12:07:26 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 29180-09
	for <pgsql-students-postgresql.org@mail.postgresql.org>;
	Sat, 26 Mar 2011 15:07:19 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cdptpa-omtalb.mail.rr.com (cdptpa-omtalb.mail.rr.com
	[75.180.132.122])
	by mail.postgresql.org (Postfix) with ESMTP id 7E6BD133740B
	for <pgsql-students@postgresql.org>;
	Sat, 26 Mar 2011 12:07:19 -0300 (ADT)
X-Authority-Analysis: v=1.1 cv=2pE2Kh9Ye2ywHyyFZnC5ZQ1FvuPrdOtuPO5uN4ysVDU=
	c=1 sm=0 a=YOqqrsh--ucA:10 a=r6Jiw2x_onsA:10 a=8nJEP1OIZ-IA:10
	a=qCTYjJJ2g1SgQhsHZAUATw==:17 a=epTmVMiNAAAA:8
	a=RbiJVo_cxWiHys3y7R4A:9 a=Z6IrFThzw18ycmL1GgoA:7
	a=FgQUcE5K0gZGX6yk4gk8tQ0g4IIA:4 a=wPNLvfGTeEIA:10
	a=H47jIOvrWu8A:10 a=qCTYjJJ2g1SgQhsHZAUATw==:117
X-Cloudmark-Score: 0
X-Originating-IP: 98.27.48.207
Received: from [98.27.48.207] ([98.27.48.207:56303] helo=[192.168.10.104])
	by cdptpa-oedge03.mail.rr.com (envelope-from <andrew@dunslane.net>)
	(ecelerity 2.2.3.46 r()) with ESMTP
	id D9/C1-05159-5210E8D4; Sat, 26 Mar 2011 15:07:18 +0000
Message-ID: <4D8E0125.9060905@dunslane.net>
Date: Sat, 26 Mar 2011 11:07:17 -0400
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.13) Gecko/20101209 Fedora/3.1.7-0.35.b3pre.fc13
	Lightning/1.0b3pre Thunderbird/3.1.7
MIME-Version: 1.0
To: Zheng Yang <zhengyang4k@gmail.com>
CC: Shiv <rama.theone@gmail.com>, Selena Deckelmann <selena@chesnok.com>,
	Alvaro Herrera <alvherre@commandprompt.com>,
	Guillaume Lelarge <guillaume@lelarge.info>,
	pgsql-students <pgsql-students@postgresql.org>
Subject: Re: foreign data wrappers
References: <AANLkTi=FhaO5mX_YdqqsF1Yh0YNEHW8H1f0AUdpE0Fmo@mail.gmail.com>
	<690867AB-C50B-4354-91D0-8A0811639C4C@gmail.com>
	<AANLkTimKc4Jb4ydk=GO3shdv0gTPyad+y9z_kXXVKZoq@mail.gmail.com>
	<4D879CD0.5030803@dunslane.net>
	<AANLkTi=0KD_ef9XDJde52nb0n5YgysMHTjWwkKZurDR-@mail.gmail.com>
	<3EF9E4CC-CF42-4B45-86FF-4CB9D46D7442@gmail.com>
	<4D8AF8C2.3000007@lelarge.info>
	<4ACC318A-1B6F-49A5-9B02-49EEAF7B97C7@gmail.com>
	<1300985156-sup-3058@alvh.no-ip.org>
	<47676.208.91.122.102.1300985713.squirrel@dunslane.net>
	<AANLkTinCjkp2rxwivGVXZj5=bYpa4Bx=X0w6BWR=Vm0Q@mail.gmail.com>
	<AANLkTi=NuFBQBhtEBuaPR9ZzhnqPCaVtpsuJ-eZ21GpF@mail.gmail.com>
	<603812A0-F464-44AE-8A90-DF9BD1DC2DB9@gmail.com>
In-Reply-To: <603812A0-F464-44AE-8A90-DF9BD1DC2DB9@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201103/33
X-Sequence-Number: 174



On 03/24/2011 10:07 PM, Zheng Yang wrote:
>
>
> I've briefly gone through the slides. Regarding the 6 callbacks, is 
> that correct to say that a full table scan will always be performed 
> irregardless of the sql statement,
> the FDW is blind to the sql query performed, right?

Yes, fairly much. If the feed is large you need some way to pass a limit 
to the foreign side, possibly via table options. I'm fairly sure you 
won't be able to get it via the SELECT statement.

>
> And can anyone help explain what a planner is? What does this "provide 
> cost estimates to planner" mean? Thanks!


See <http://www.postgresql.org/docs/current/static/planner-optimizer.html>

If you're going to work on PostgreSQL code you need to read the docs.

cheers

andrew