Re: Logical replication with temporary tables

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Stuart Campbell <stuart(dot)campbell(at)ridewithvia(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Logical replication with temporary tables
Date: 2024-07-03 00:49:57
Message-ID: 0FE55AC1-25C2-4B5B-A312-5F8EB4756B4B@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jul 2, 2024, at 17:47, Stuart Campbell <stuart(dot)campbell(at)ridewithvia(dot)com> 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 writing to the WAL?)

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Campbell 2024-07-03 01:16:42 Re: Logical replication with temporary tables
Previous Message Stuart Campbell 2024-07-03 00:47:32 Logical replication with temporary tables