Re: Replication on the backend

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: Gustavo Tonini <gustavotonini(at)gmail(dot)com>
Cc: Jan Wieck <JanWieck(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Replication on the backend
Date: 2005-12-06 13:10:44
Message-ID: 1133874644.12941.27.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, 2005-12-06 at 10:03 -0200, Gustavo Tonini wrote:
> But, wouldn't the performance be better? And wouldn't asynchronous
> messages be better processed?

At least for synchronous multi-master replication, the performance
bottelneck is going to be the interconnect between the nodes -
integration of the replication logic into the backend most probably
doesn't affect performance that much.

I'd rather like to ask Jan what different needs for replication he
discovered so far. And how he came to the conclusion, that it's not
possible to provide a general solution.

My point for integration into the backend is flexibility: obviously the
replication code can influence the database much more from within the
backend than from the outside. For example running one complex query on
several nodes. I know, this a very advanced feature - currently it's not
even possible to run one query on multiple backends (i.e. processors of
a multi-core system) - but I like to plan ahead instead of throwing away
code later. For such advanced features you simply have to dig around in
the backend code one day. Of course you can always add hooks, but IMHO
that only complicates matters.

Is there some discussion going on about such topics somewhere? What's up
with slony-2? The wiki on still doesn't provide a lot of
technical information (and obviously got spammed BTW).



In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-12-06 13:11:56 Re: [PATCHES] snprintf() argument reordering not working
Previous Message Gustavo Tonini 2005-12-06 12:03:02 Re: Replication on the backend