On Tuesday, July 2, 2024, Stuart Campbell
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
> table
> On Jul 2, 2024, at 18:16, Stuart Campbell
> 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
>
> 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.
My understanding was that under the hood, AWS uses the logical replication
features that are present in community Postgres. If that's in
> On Jul 2, 2024, at 17:47, Stuart Campbell
> wrote:
> My question is whether there is some workaround that will let me create
> indexes on a temporary table, and also let me drop the temporary table, in a
> way that doesn't end up "degrading" replication? (Presumably that means
> avoiding
Hello,
I'm trying to use a blue/green deployment in Amazon RDS, which uses
Postgres logical replication to keep blue and green environments in sync.
Some parts of our app use temporary tables, and in some cases we CREATE
INDEX on those tables and sometimes DROP and recreate them.
The CREATE INDE
