Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4E41F650EC8 for ; Thu, 26 Jun 2008 17:57:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66040-04 for ; Thu, 26 Jun 2008 17:57:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by postgresql.org (Postfix) with ESMTP id 4031C650EBC for ; Thu, 26 Jun 2008 17:57:24 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so111050yxb.73 for ; Thu, 26 Jun 2008 13:57:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=1fHEbLRKtbHC7MIWVlFaJuOAZTYR0TIuyJp7k9AhejU=; b=QdRitUfsf16f1WDPu6rEeELa5CsSnavvUyfnx8+JOKjXDL68LlWKBpskqTlC+sjQ1r xTLOIrTqV/nM/kr87A6K6F7wf6vxuzgS911hHjLR46lSLxBFQ1rAzQziD3vdHW1LpwkI 5YAxcB3d/Un/w35Z5/gHTylm9RFwQMvBfM4I0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=TgGFGQhwWAmmWybXCv0kc70aKpMnA2yJ8Tetgy4hLqOA6iNDFdmLzCSwikibdnqjuu KX0PBlEPVJXimMA2OfNkCt8XPIBiC6ekQ4Mwim+ax4/PrsLTa1tnVN1KNLBXcaVCjo4s +K2KPjLW/zPeUn5pjfI4GN1qOCd6WxM7CyMAw= Received: by 10.150.58.1 with SMTP id g1mr789142yba.85.1214513843121; Thu, 26 Jun 2008 13:57:23 -0700 (PDT) Received: by 10.150.57.2 with HTTP; Thu, 26 Jun 2008 13:57:23 -0700 (PDT) Message-ID: <36e682920806261357h48fa718alc13dce455d6ddaa2@mail.gmail.com> Date: Thu, 26 Jun 2008 16:57:23 -0400 From: "Jonah H. Harris" To: "kevin kempter" Subject: Re: Federated Postgresql architecture ? Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/184 X-Sequence-Number: 30534 On Thu, Jun 26, 2008 at 4:33 PM, kevin kempter 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/