Re: Core team statement on replication in PostgreSQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Core team statement on replication in PostgreSQL
Date
Msg-id 5164.1213062658@sss.pgh.pa.us
Whole thread Raw
In response to Re: Core team statement on replication in PostgreSQL  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Core team statement on replication in PostgreSQL  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Gurjeet Singh wrote:
>> There could be multiple slaves following a master, some serving

> For the slave to not interfere with the master at all, we would need to
> delay application of WAL files on each slave until visibility on that
> slave allows the WAL to be applied, but in that case we would have
> long-running transactions delay data visibility of all slave sessions.

Right, but you could segregate out long-running queries to one slave
server that could be further behind than the others.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Core team statement on replication in PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Core team statement on replication in PostgreSQL