Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E520D1337B8B for ; Thu, 24 Mar 2011 23:07:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 47872-05 for ; Fri, 25 Mar 2011 02:07:27 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id 33BC91337990 for ; Thu, 24 Mar 2011 23:07:25 -0300 (ADT) Received: by iyb14 with SMTP id 14so21616iyb.19 for ; Thu, 24 Mar 2011 19:07:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:mime-version:content-type:from :in-reply-to:date:cc:message-id:references:to:x-mailer; bh=Rp/ccUpojcLsRFMf4AEyGxvKp6KZeSEy6rL3cbvIfbU=; b=M0OMJZT+WuuY+jjCikwCiFXgXJ6d7LPtaCUy6DzmZpuHLtLxLZ764CSHhVx4glvD2R aAQJ1nN3IYVeLTenbn5PY84CbEBRaWm+NTPr8WzmkHpn+Ke7kL+bW7I4zo0avQpw3Yd4 +KcrkeO8YMK3q2hlKcLRnJnKVYU4D+Oef0Qao= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :message-id:references:to:x-mailer; b=HfjUykl4+0m/U9fT70R1IC5Dnoecu/KMZsQL6r9FqLObwM5kbdFxG5MeeSuMrA7up2 cofQAp6fpEvhCwBg8L7VdK5PUdS1CLzdUoj1//ulV+epq5WCzkn9k5vPMpOTDa1aOtF8 Vn9tH2H33mB0En5H3u1PV+fFPKfZoY/L0bVKM= Received: by 10.42.147.134 with SMTP id n6mr313548icv.216.1301018845477; Thu, 24 Mar 2011 19:07:25 -0700 (PDT) Received: from [122.64.182.61] ([61.158.124.105]) by mx.google.com with ESMTPS id xa13sm264374icb.15.2011.03.24.19.07.15 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 24 Mar 2011 19:07:19 -0700 (PDT) Subject: Re: foreign data wrappers Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: multipart/alternative; boundary=Apple-Mail-772-589084906 From: Zheng Yang In-Reply-To: Date: Fri, 25 Mar 2011 10:07:11 +0800 Cc: Selena Deckelmann , Andrew Dunstan , Alvaro Herrera , Guillaume Lelarge , pgsql-students Message-Id: <603812A0-F464-44AE-8A90-DF9BD1DC2DB9@gmail.com> References: <690867AB-C50B-4354-91D0-8A0811639C4C@gmail.com> <4D879CD0.5030803@dunslane.net> <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> To: Shiv X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201103/26 X-Sequence-Number: 167 --Apple-Mail-772-589084906 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Thanks for the slides! As what's mentioned on one of the slides, the = datasource of FDW can be virtually everything. So if there were a FDW for flickr API, the examples will be something = like: 1) CREATE FOREIGN TABLE flickr_table (photo_id INT, ownerid INT, photo = BLOB, text TEXT) SERVER flick_fdw OPTIONS (api_key 'AAAA'); =20 p.s. the text field is used as the keyword for free text search. when query from the table: 2) SELECT photo FROM flickr_table WHERE text =3D 'panda' LIMIT 0, 10; This will return top ten photos relevant to 'panda'. Is my understanding = correct? 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? And can anyone help explain what a planner is? What does this "provide = cost estimates to planner" mean? Thanks! Hi Shiv, I am also from National University of Singapore! cheers, ZY On 25-Mar-2011, at 8:53 AM, Shiv wrote: > Thank you for the slides. And yes FDW seems like a good project to get = involved in especially if one (and by one I mean me) is knew to the = Postgres codebase. > Regards, > Shiv >=20 >=20 > On Fri, Mar 25, 2011 at 4:59 AM, Selena Deckelmann = wrote: > And, Andrew's slides from his talk today are now available: > http://people.planetpostgresql.org/andrew/uploads/fdw2.pdf >=20 > We really think the FDW projects would be great ones for GSoC. I know > we said that already. :) >=20 > -selena >=20 > -- > Sent via pgsql-students mailing list (pgsql-students@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-students >=20 --Apple-Mail-772-589084906 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii

Hi Shiv, I am also from National = University of = Singapore!

cheers,
ZY

On 25-Mar-2011, at 8:53 AM, Shiv = wrote:

Thank you for the slides. And yes FDW seems like a good = project to get involved in especially if one (and by one I mean me) is = knew to the Postgres codebase.
Regards,
Shiv


On Fri, Mar 25, 2011 at 4:59 AM, = Selena Deckelmann <selena@chesnok.com> = wrote:
And, Andrew's slides from his talk today are now available:
http://people.planetpostgresql.org/andrew/uploads/fdw2.p= df

We really think the FDW projects would be great ones for GSoC. I = know
we said that already. :)

-selena

--
Sent via pgsql-students mailing list (pgsql-students@postgresql.or= g)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students


= --Apple-Mail-772-589084906--