Re: foreign data wrappers
От
Zheng Yang
Тема
Re: foreign data wrappers
Дата
Msg-id
E7108617-4213-4C33-B5C8-D510B65EC34D@gmail.com
Ответ на
Re: foreign data wrappers (Andrew Dunstan)
Список
Дерево обсуждения
query execution time preetika tyagi <preetikatyagi@gmail.com>
foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Selena Deckelmann <selena@chesnok.com>
Re: foreign data wrappers Andrew Dunstan <andrew@dunslane.net>
Re: foreign data wrappers Selena Deckelmann <selena@chesnok.com>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Guillaume Lelarge <guillaume@lelarge.info>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Alvaro Herrera <alvherre@commandprompt.com>
Re: foreign data wrappers "Andrew Dunstan" <andrew@dunslane.net>
Re: foreign data wrappers Selena Deckelmann <selena@chesnok.com>
Re: foreign data wrappers Shiv <rama.theone@gmail.com>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Andrew Dunstan <andrew@dunslane.net>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Guillaume Lelarge <guillaume@lelarge.info>
Re: foreign data wrappers Andrew Dunstan <andrew@dunslane.net>
Re: foreign data wrappers Guillaume Lelarge <guillaume@lelarge.info>
Re: foreign data wrappers Andrew Dunstan <andrew@dunslane.net>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Selena Deckelmann <selena@chesnok.com>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Guillaume Lelarge <guillaume@lelarge.info>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Selena Deckelmann <selena@chesnok.com>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Dave Page <dpage@pgadmin.org>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: foreign data wrappers Shiv <rama.theone@gmail.com>
Re: foreign data wrappers Shiv <rama.theone@gmail.com>
Re: foreign data wrappers Zheng Yang <zhengyang4k@gmail.com>
Re: query execution time Selena Deckelmann <selena@chesnok.com>
Hi,
I managed to clone a copy of 9.1devel and compiled an binary from it. I also did a make in the 'contrib/file_fdw/' folder and a file_fdw.so file is generated.
But the following error occurs when I was trying to experiment with the file FDW:
postgres=# CREATE FUNCTION file_fdw_handler() RETURNS fdw_handler AS 'file_fdw' LANGUAGE C STRICT;
ERROR: could not access file "file_fdw": No such file or directory
STATEMENT: CREATE FUNCTION file_fdw_handler() RETURNS fdw_handler AS 'file_fdw' LANGUAGE C STRICT;
ERROR: could not access file "file_fdw": No such file or directory
Did I miss anything?
ZY
On 26-Mar-2011, at 11:07 PM, Andrew Dunstan wrote:
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
В списке pgsql-students по дате отправления
