X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0FB4452886 for ; Tue, 28 Jun 2005 00:32:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95758-06 for ; Tue, 28 Jun 2005 03:32:05 +0000 (GMT) Received: from smtp005.bizmail.sc5.yahoo.com (smtp005.bizmail.sc5.yahoo.com [66.163.175.82]) by svr1.postgresql.org (Postfix) with SMTP id 063865294F for ; Tue, 28 Jun 2005 00:32:03 -0300 (ADT) Received: from unknown (HELO ?192.168.3.41?) (david.mitchell@telogis.com@203.98.10.169 with plain) by smtp005.bizmail.sc5.yahoo.com with SMTP; 28 Jun 2005 03:31:56 -0000 Message-ID: <42C0C4A4.9090809@telogis.com> Date: Tue, 28 Jun 2005 15:31:48 +1200 From: David Mitchell User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Kings-Lynne Cc: pgsql-performance@postgresql.org Subject: Re: How can I speed up this function? References: <42C0B7EE.4040608@telogis.com> <42C0BE50.3090105@familyhealth.com.au> <42C0BFC6.7070507@telogis.com> <42C0C204.1030301@familyhealth.com.au> In-Reply-To: <42C0C204.1030301@familyhealth.com.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/523 X-Sequence-Number: 13160 Christopher Kings-Lynne wrote: > > I'm curious - how did you write a multi-master replication package in > pgsql, when pgsql doesn't have 2 phase commits or any kind of > distributed syncing or conflict resolution in a release version? We didn't write it entirely in pgsql, there is a worker process that takes care of actually committing to the database. Cheers -- David Mitchell Software Engineer Telogis