Re: Logical replication with temporary tables

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Logical replication with temporary tables
Дата
Msg-id B6B249F8-FF16-4846-AA97-97F100C5F606@thebuild.com
обсуждение исходный текст
Ответ на Re: Logical replication with temporary tables  (Stuart Campbell <stuart.campbell@ridewithvia.com>)
Список pgsql-general

> On Jul 2, 2024, at 18:16, Stuart Campbell <stuart.campbell@ridewithvia.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
stateto 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
theWAL? 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
currentversions of PostgreSQL. 


В списке pgsql-general по дате отправления: