Re: Future In-Core Replication

On Sat, 2012-04-28 at 21:40 +0200, Hannu Krosing wrote:
> On Sat, 2012-04-28 at 09:36 +0100, Simon Riggs wrote:
> > On Fri, Apr 27, 2012 at 11:50 PM, Christopher Browne <cbbrowne(at)gmail(dot)com> wrote:
> > > On Fri, Apr 27, 2012 at 4:11 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > >> What I'm hoping to do is to build a basic prototype of logical
> > >> replication using WAL translation, so we can inspect it to see what
> > >> the downsides are. It's an extremely non-trivial problem and so I
> > >> expect there to be mountains to climb. There are other routes to
> > >> logical replication, with messages marshalled in a similar way to
> > >> Slony/Londiste/Bucardo/Mammoth(?). So there are options, with
> > >> measurements to be made and discussions to be had.
> > >
> > > I'll note that the latest version of Slony ...has made a substantial change to its data
> > > representation....

Btw, Londiste has also moved from Slony-like trigger with partial SQL to
more general format a few versions ago.

I sure hope they will move to JSON as the data representation now when
we'll have JSON in core in 9.2

--
-------
Hannu Krosing
PostgreSQL Unlimited Scalability and Performance Consultant
2ndQuadrant Nordic
PG Admin Book: http://www.2ndQuadrant.com/books/