MIME-Version: 1.0
In-Reply-To: <CAAZ6Snxs+6si7gP5yrLNeGAzFgf9_mL1Di+C-_kOAW+96vs+xg@mail.gmail.com>
References: <CAAZ6SnzRU=qo2nedBa6ESOHfV=WaRJk+UW5DUrxkVMu6Gjpwng@mail.gmail.com>
 <0FE55AC1-25C2-4B5B-A312-5F8EB4756B4B@thebuild.com> <CAAZ6Snxs+6si7gP5yrLNeGAzFgf9_mL1Di+C-_kOAW+96vs+xg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 2 Jul 2024 18:19:51 -0700
Message-ID: <CAKFQuwYxezBvDNFpojam79cDvjzFoRCs+gAbGG+6v6Y9zs2zZw@mail.gmail.com>
Subject: Re: Logical replication with temporary tables
To: Stuart Campbell <stuart.campbell@ridewithvia.com>
Cc: Christophe Pettus <xof@thebuild.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008fad97061c4da0f7"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYxezBvDNFpojam79cDvjzFoRCs%2BgAbGG%2B6v6Y9zs2zZw%40mail.gmail.com>
Precedence: bulk

--0000000000008fad97061c4da0f7
Content-Type: text/plain; charset="UTF-8"

On Tuesday, July 2, 2024, Stuart Campbell <stuart.campbell@ridewithvia.com>
wrote:

> 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.
>
>
> 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?
>
>
Yes, and no.  The tables those commands update are WAL-logged and that
status is all-or-nothing.

David J.

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

On Tuesday, July 2, 2024, Stuart Campbell &lt;<a href=3D"mailto:stuart.camp=
bell@ridewithvia.com">stuart.campbell@ridewithvia.com</a>&gt; wrote:<br><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t: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>Maybe my question can be re-sum=
marised as: do DDL operations on temporary tables necessarily have to be wr=
itten to the WAL? Is there a way to avoid that?<br></div></div></div>

<div><br></div></blockquote><div><br></div><div>Yes, and no.=C2=A0 The tabl=
es those commands update are WAL-logged and that status is all-or-nothing.<=
/div><div><br></div><div>David J.</div><div><br></div><div>=C2=A0</div>

--0000000000008fad97061c4da0f7--