From: Jonah H. Harris <jonah.harris@gmail.com>
To: kevin kempter <kevin@kevinkempterllc.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Federated Postgresql architecture ?
Date: Thu, 26 Jun 2008 16:57:23 -0400
Message-ID: <36e682920806261357h48fa718alc13dce455d6ddaa2@mail.gmail.com> (raw)
In-Reply-To: <C401CB24-5BD6-455B-A62B-9D737E44CEB3@kevinkempterllc.com>
References: <C401CB24-5BD6-455B-A62B-9D737E44CEB3@kevinkempterllc.com>
On Thu, Jun 26, 2008 at 4:33 PM, kevin kempter
<kevin@kevinkempterllc.com> wrote:
> Anyone have any experiences to share per setting up a federated architecture
> with PostgreSQL ? I wonder if the dblink contrib works well in a federated
> scenario, specifically in the setup of the federated views which equate to a
> select * from the same table on each federated server ?
Because Postgres currently lacks the ability to push down predicates
to individual nodes over a database link, you have to spend a good
amount of time writing PL set-returning functions capable of adding
appropriate WHERE clauses to queries sent over the link. There are
other things you can do, but it's mostly hackery at this point in
time. IIRC, David Fetter is trying to get some of the required
predicate information exposed for use in DBI-Link.
Not to self-plug, but if you require it, EnterpriseDB includes
Oracle-style database links (SELECT col FROM table@node) which support
predicate push-down.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: jonah.harris@gmail.com, kevin@kevinkempterllc.com
Subject: Re: Federated Postgresql architecture ?
In-Reply-To: <36e682920806261357h48fa718alc13dce455d6ddaa2@mail.gmail.com>
References: <C401CB24-5BD6-455B-A62B-9D737E44CEB3@kevinkempterllc.com> <36e682920806261357h48fa718alc13dce455d6ddaa2@mail.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