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

Re: foreign data wrappers

From: Zheng Yang <zhengyang4k(at)gmail(dot)com>
To: Selena Deckelmann <selena(at)chesnok(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-26 02:23:47
Message-ID: DF55FA8B-B241-4C2F-803C-424D264B5AF3@gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-students
Thanks!

Can anyone help on this:

I wanted to check out an copy of pgsql source so that I can start playing around with it. 
I followed the working with git instructions here:

http://wiki.postgresql.org/wiki/Working_with_Git

but when I run this command:
git clone git://git.postgresql.org/git/postgresql.git

I get this error:
Cloning into gitpostgresql...
fatal: The remote end hung up unexpectedly


ZY


On 25-Mar-2011, at 11:38 PM, Selena Deckelmann wrote:

> 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: Dave PageDate: 2011-03-26 08:11:06
Subject: Re: foreign data wrappers
Previous:From: Selena DeckelmannDate: 2011-03-25 15:38:01
Subject: Re: foreign data wrappers

pgsql-general by date

Next:From: Yang ZhangDate: 2011-03-26 02:58:40
Subject: Disk space usage analyzer?
Previous:From: Jake StrideDate: 2011-03-25 22:18:50
Subject: Using data for column names in plpgsql

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