[pgpool-general: 1532] Re: foreign data wrappers support?

[Tatsuo Ishii]

> Greetings,
> I checked the official dox, but didn't see any mention of how foreign
> data wrappers (FDW:
> http://www.postgresql.org/docs/9.2/static/sql-createserver.html ) are
> handled inside pgpool.  Is it completely transparent, such that the
> same rules for write queries apply to queries that involve foreign
> data wrappers?

Yes, I think so. I have tried file_fdw with pgpool-II streaming
replication setting and it seems working.

> I'm mostly thinking & planning for 9.3 when a postgres FDW will be
> supported ( http://www.postgresql.org/docs/devel/static/postgres-fdw.html
> ).  This opens up a lot of new & interesting possibilities, especially
> with respect to clustering & load balancing, as it will be (somewhat)
> trivially possible to access different clusters from each other.

Can you elaborate on clustering & load balancing by using pgsql_fdw
with pgpool-II?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp