Re: Logical replication with temporary tables

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