Re: Proposal for 9.1: WAL streaming from WAL buffers - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Proposal for 9.1: WAL streaming from WAL buffers
Date
Msg-id 4C17DB12.9030905@agliodbs.com
Whole thread Raw
In response to Re: Proposal for 9.1: WAL streaming from WAL buffers  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Proposal for 9.1: WAL streaming from WAL buffers
List pgsql-hackers
> I wonder if it would be possible to jigger things so that we send the
> WAL to the standby as soon as it is generated, but somehow arrange
> things so that the standby knows the last location that the master has
> fsync'd and never applies beyond that point.

I can't think of any way which would not require major engineering.  And
you'd be slowing down replication *in general* to deal with a fairly
unlikely corner case.

I think the panic is the way to go.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PERFORM] No hash join across partitioned tables?
Next
From: Robert Haas
Date:
Subject: Re: Proposal for 9.1: WAL streaming from WAL buffers