Search Postgresql Archives

Re: Logical replication with temporary tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Jul 2, 2024, at 18:16, Stuart Campbell <stuart.campbell@xxxxxxxxxxxxxxx> 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.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux