X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1EDBE9FB2F0 for ; Thu, 10 Aug 2006 11:00:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21375-02 for ; Thu, 10 Aug 2006 11:00:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from dcs.lsd.di.uminho.pt (linux.di.uminho.pt [193.136.19.96]) by postgresql.org (Postfix) with ESMTP id B02219FB2DA for ; Thu, 10 Aug 2006 11:00:35 -0300 (ADT) Received: (qmail 17107 invoked by uid 89); 10 Aug 2006 14:19:33 -0000 Received: from unknown (HELO abulafia.lsd.di.uminho.pt.82.168.192.in-addr.arpa) (192.168.82.68) by dcs.lsd.di.uminho.pt with SMTP; 10 Aug 2006 14:19:32 -0000 From: =?utf-8?q?Jos=C3=A9_Orlando_Pereira?= Organization: http://gsd.di.uminho.pt/members/jop To: pgsql-hackers@postgresql.org, Markus Schiltknecht Subject: Re: standard interfaces for replication providers Date: Thu, 10 Aug 2006 15:00:15 +0100 User-Agent: KMail/1.9.3 Cc: Hannu Krosing , "Jim C. Nasby" , alfranio correia junior , Christopher Browne References: <44D30B31.2070403@lsd.di.uminho.pt> <20060809185609.GK40481@pervasive.com> <1155153468.5899.12.camel@localhost.localdomain> In-Reply-To: <1155153468.5899.12.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608101500.16468.jop@lsd.di.uminho.pt> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.72 tagged_above=0 required=5 tests=SARE_SPEC_REPLICA X-Spam-Level: X-Archive-Number: 200608/702 X-Sequence-Number: 88195 On Wednesday 09 August 2006 20:57, Hannu Krosing wrote: > > > > Why reinvent the wheel for everything if there was an interface that > > offered some of the needed functionality? Maybe PostgreSQL-R is simply > > too deep in the database for any of this to be useful, but I'm 99% > > certain that Slony could make use of some of this stuff, such as a hook > > on tuples being written out. > > Slonys problems ar *not* in getting access to tuples written out. Why > fix something that aint broken ? The current implementation of GAPI on PostgreSQL uses the same approach as Slony-I to extract the write-set. The difference is that it can push them out immediatly on commit, as required for eager update. -- Jose Orlando Pereira