public inbox for [email protected]
help / color / mirror / Atom feedFrom: Nathan Bossart <[email protected]>
To: Andres Freund <[email protected]>
Cc: Bharath Rupireddy <[email protected]>
Cc: Kyotaro Horiguchi <[email protected]>
Cc: SATYANARAYANA NARLAPURAM <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: Allow async standbys wait for sync replication
Date: Sat, 12 Mar 2022 14:33:32 -0800
Message-ID: <20220312223332.GA921069@nathanxps13> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<20220301170537.GA1031413@nathanxps13>
<CALj2ACUdNd=vVTOdz=UMuWxTVJgzsCUhOwJ6mMsXK150Ec-QOQ@mail.gmail.com>
<20220301212700.GB1033258@nathanxps13>
<CALj2ACULc_2TbC44fdFbpPCJ-AmvixdLY9z=LgMfz07QXx9-bg@mail.gmail.com>
<20220304195602.GA1184024@nathanxps13>
<CALj2ACUpRdtM_6RpumzNbO6D_XbSjVMfnNp5yVOnkKUnS4Z+xA@mail.gmail.com>
<[email protected]>
<CALj2ACUpgZgiPRYq545XiALZMtGJ-vfQGbUGZpCJ7i3QuAUdUg@mail.gmail.com>
<[email protected]>
On Tue, Mar 08, 2022 at 06:01:23PM -0800, Andres Freund wrote:
> To me it's architecturally the completely wrong direction. We should move in
> the *other* direction, i.e. allow WAL to be sent to standbys before the
> primary has finished flushing it locally. Which requires similar
> infrastructure to what we're discussing here.
I think this is a good point. After all, WALRead() has the following
comment:
* XXX probably this should be improved to suck data directly from the
* WAL buffers when possible.
Once you have all the infrastructure for that, holding back WAL replay on
async standbys based on synchronous replication might be relatively easy.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Allow async standbys wait for sync replication
In-Reply-To: <20220312223332.GA921069@nathanxps13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox