Re: Logical replication with temporary tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: Logical replication with temporary tables
Date
Msg-id CAKFQuwYxezBvDNFpojam79cDvjzFoRCs+gAbGG+6v6Y9zs2zZw@mail.gmail.com
Whole thread Raw
In response to Re: Logical replication with temporary tables  (Stuart Campbell <stuart.campbell@ridewithvia.com>)
List pgsql-general
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.

 

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Logical replication with temporary tables
Next
From: Muhammad Ikram
Date:
Subject: Re: Question on partman extension while relation exist