Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Logical replication with temporary tables
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAAZ6Snxs+6si7gP5yrLNeGAzFgf9_mL1Di+C-_kOAW+96vs+xg@mail.gmail.com>
Date: Tue, 2 Jul 2024 18:19:12 -0700
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <B6B249F8-FF16-4846-AA97-97F100C5F606@thebuild.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>
To: Stuart Campbell <stuart.campbell@ridewithvia.com>
Archived-At: <https://www.postgresql.org/message-id/B6B249F8-FF16-4846-AA97-97F100C5F606%40thebuild.com>
Precedence: bulk


> On Jul 2, 2024, at 18:16, Stuart Campbell =
<stuart.campbell@ridewithvia.com> wrote:
>=20
> 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.

Yes, but: The idea of a "degraded" replication is an AWS thing, so it's =
hard to say what does or does not cause that state to occur without =
access to proprietary AWS code.

> 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, they do (because they involve catalog changes that need to be =
WAL-logged), and there is no way of avoiding that in current versions of =
PostgreSQL.=