Skip site navigation (1) Skip section navigation (2)

Re: foreign data wrappers

From: Selena Deckelmann <selena(at)chesnok(dot)com>
To: Zheng Yang <zhengyang4k(at)gmail(dot)com>
Cc: Shiv <rama(dot)theone(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgsql-students <pgsql-students(at)postgresql(dot)org>
Subject: Re: foreign data wrappers
Date: 2011-03-25 15:38:01
Message-ID: AANLkTik2NSneX2bbTzWMZv96n2JUkp2uNP9TCqFH4ZEC@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-students
Hi!

On Thu, Mar 24, 2011 at 7:07 PM, Zheng Yang <zhengyang4k(at)gmail(dot)com> wrote:
> 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');
> p.s. the text field is used as the keyword for free text search.
> when query from the table:

Yes, but perhaps we could name the 'text' column something like
'search' or ... someone else could help come up with a better name. :)

> 2) SELECT photo FROM flickr_table WHERE text = 'panda' LIMIT 0, 10;
> This will return top ten photos relevant to 'panda'. Is my understanding
> correct?

Yes, the first ten results.

> 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?

That's correct.

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

Have a look at this for a quick overview:
http://www.postgresql.org/docs/9.0/static/planner-optimizer.html

-selena

-- 
http://chesnok.com

In response to

Responses

pgsql-students by date

Next:From: Zheng YangDate: 2011-03-26 02:23:47
Subject: Re: foreign data wrappers
Previous:From: ShivDate: 2011-03-25 04:56:40
Subject: Re: foreign data wrappers

pgsql-general by date

Next:From: Richard HuxtonDate: 2011-03-25 15:57:24
Subject: Re: psql can't subtract
Previous:From: Rob SargentDate: 2011-03-25 15:29:57
Subject: psql can't subtract

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group