pg.ddx.io pgsql-general@postgresql.org mailing list archive help / color / mirror / Atom feed From: Zheng Yang <zhengyang4k@gmail.com>
To: Selena Deckelmann <selena@chesnok.com>
Cc: Shiv <rama.theone@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-students <pgsql-students@postgresql.org>
Subject: Re: foreign data wrappers
Date: Sat, 26 Mar 2011 10:23:47 +0800
Message-ID: <DF55FA8B-B241-4C2F-803C-424D264B5AF3@gmail.com> (raw )
In-Reply-To: <AANLkTik2NSneX2bbTzWMZv96n2JUkp2uNP9TCqFH4ZEC@mail.gmail.com >
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 >
<AANLkTik2NSneX2bbTzWMZv96n2JUkp2uNP9TCqFH4ZEC@mail.gmail.com >
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@gmail.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
view thread (37+ messages) latest in thread
Message-ID: <DF55FA8B-B241-4C2F-803C-424D264B5AF3@gmail.com>
Permalink: ../DF55FA8B-B241-4C2F-803C-424D264B5AF3@gmail.com/
Also on: postgresql.org/message-id/DF55FA8B-B241-4C2F-803C-424D264B5AF3@gmail.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: zhengyang4k@gmail.com, selena@chesnok.com, rama.theone@gmail.com, andrew@dunslane.net, alvherre@commandprompt.com, guillaume@lelarge.info, pgsql-students@postgresql.org
Subject: Re: foreign data wrappers
In-Reply-To: <DF55FA8B-B241-4C2F-803C-424D264B5AF3@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox