Re: Logical replication with temporary tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Logical replication with temporary tables
Дата
Msg-id CAKFQuwYxezBvDNFpojam79cDvjzFoRCs+gAbGG+6v6Y9zs2zZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical replication with temporary tables  (Stuart Campbell <stuart.campbell@ridewithvia.com>)
Список 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 по дате отправления: