MIME-Version: 1.0
References: <CAHYXj6eE0jMyeM-c-szjzDLVB6WSD=bYH3KiCgZ2s8f3Z_HV9Q@mail.gmail.com>
 <CO1PR19MB498475E00A86044B340A0B399B462@CO1PR19MB4984.namprd19.prod.outlook.com>
In-Reply-To: <CO1PR19MB498475E00A86044B340A0B399B462@CO1PR19MB4984.namprd19.prod.outlook.com>
From: Jacob Biesinger <jake.biesinger@gmail.com>
Date: Wed, 16 Oct 2024 12:24:32 -0700
Message-ID: <CAHYXj6ecNTdHVmx-+4AZMx7SQ-Po6W09AoFsDT+QKdfXGxD9Hw@mail.gmail.com>
Subject: Re: serializable master and non-serializable hot standby: feasible
 set up?
To: "Clay Jackson (cjackson)" <Clay.Jackson@quest.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a8a06c06249d05b3"
Archived-At: <https://www.postgresql.org/message-id/CAHYXj6ecNTdHVmx-%2B4AZMx7SQ-Po6W09AoFsDT%2BQKdfXGxD9Hw%40mail.gmail.com>
Precedence: bulk

--000000000000a8a06c06249d05b3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

>
> Just out of curiosity, what=E2=80=99s the use case for this?
>
>
We use the read-only replica as a data source for analytics workflows. The
setup allows us to have fresh data without affecting performance of the
production environment.

--000000000000a8a06c06249d05b3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><div class=3D"msg4713035467727740875"><div lang=3D"EN-US=
" style=3D"overflow-wrap: break-word;"><div class=3D"m_4713035467727740875W=
ordSection1"><p class=3D"MsoNormal"><span style=3D"font-size:11pt">Just out=
 of curiosity, what=E2=80=99s the use case for this?<u></u><u></u></span></=
p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u></span></p></d=
iv></div></div></blockquote><div><br></div><div>We use the read-only replic=
a as a data source for analytics workflows. The setup allows us to have fre=
sh data without affecting performance of the production environment.</div><=
div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=
=3D"msg4713035467727740875"><div lang=3D"EN-US" style=3D"overflow-wrap: bre=
ak-word;"><div class=3D"m_4713035467727740875WordSection1"><div><div><div><=
div><div><div><div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

</div></blockquote></div></div>

--000000000000a8a06c06249d05b3--