MIME-Version: 1.0
References: <CAAZ6SnzRU=qo2nedBa6ESOHfV=WaRJk+UW5DUrxkVMu6Gjpwng@mail.gmail.com>
 <0FE55AC1-25C2-4B5B-A312-5F8EB4756B4B@thebuild.com>
In-Reply-To: <0FE55AC1-25C2-4B5B-A312-5F8EB4756B4B@thebuild.com>
From: Stuart Campbell <stuart.campbell@ridewithvia.com>
Date: Wed, 3 Jul 2024 11:16:42 +1000
Message-ID: <CAAZ6Snxs+6si7gP5yrLNeGAzFgf9_mL1Di+C-_kOAW+96vs+xg@mail.gmail.com>
Subject: Re: Logical replication with temporary tables
To: Christophe Pettus <xof@thebuild.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000eaac1e061c4d95ff"
Archived-At: <https://www.postgresql.org/message-id/CAAZ6Snxs%2B6si7gP5yrLNeGAzFgf9_mL1Di%2BC-_kOAW%2B96vs%2Bxg%40mail.gmail.com>
Precedence: bulk

--000000000000eaac1e061c4d95ff
Content-Type: text/plain; charset="UTF-8"

>
> This is a question for AWS.  Community PostgreSQL doesn't have any of
> these concepts, and this is all proprietary modifications to PostgreSQL by
> Amazon.


My understanding was that under the hood, AWS uses the logical replication
features that are present in community Postgres. If that's incorrect then
I'm sorry for the off-topic post.

Maybe my question can be re-summarised as: do DDL operations on temporary
tables necessarily have to be written to the WAL? Is there a way to avoid
that?

-- 
This communication and any attachments may contain confidential information 
and are intended to be viewed only by the intended recipients. If you have 
received this message in error, please notify the sender immediately by 
replying to the original message and then delete all copies of the email 
from your systems.


--000000000000eaac1e061c4d95ff
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">
This is a question for AWS.=C2=A0 Community PostgreSQL doesn&#39;t have any=
 of these concepts, and this is all proprietary modifications to PostgreSQL=
 by Amazon.</blockquote><div><br></div><div>My understanding was that under=
 the hood, AWS uses the logical replication features that are present in co=
mmunity Postgres. If that&#39;s incorrect then I&#39;m sorry for the off-to=
pic post.<br></div><div><br></div><div>Maybe my question can be re-summaris=
ed as: do DDL operations on temporary tables necessarily have to be written=
 to the WAL? Is there a way to avoid that?<br></div></div></div>

<br>
<div>This communication and any attachments may contain confidential inform=
ation and are intended to be viewed only by the intended recipients. If you=
 have received this message in error, please notify the sender immediately =
by replying to the original message and then delete all copies of the email=
 from your systems.</div><div><br></div><div><br></div>
--000000000000eaac1e061c4d95ff--