Skip site navigation (1) Skip section navigation (2)

Re: Streaming replication, and walsender during recovery

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Streaming replication, and walsender during recovery
Date: 2010-01-28 18:58:19
Message-ID: 1264705099.24669.11475.camel@ebony (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, 2010-01-28 at 20:49 +0200, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > I'm a little worried the feature set of streaming rep isn't any better
> > than what we have already.
> 
> Huh? Are you thinking of the "Record-based Log Shipping" described in
> the manual, using a program to poll pg_xlogfile_name_offset() in a tight
> loop, as a replacement for streaming replication? First of all, that
> requires a big chunk of custom development, so it's a bit of a stretch
> to say we have it already. 

It's been part of Skytools for years now...

> Secondly, with that method, the standby still
>  still be replaying the WAL one file at a time, which makes a difference
> with Hot Standby.

I'm not attempting to diss Streaming Rep, or anyone involved. What has
been done is good internal work. I am pointing out and requesting that
we should have a little more added before we stop for this release.

-- 
 Simon Riggs           www.2ndQuadrant.com


In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-01-28 19:00:33
Subject: Re: Streaming replication, and walsender during recovery
Previous:From: Greg StarkDate: 2010-01-28 18:57:50
Subject: Re: Review: listagg aggregate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group