Re: Logical Replication and table bloat - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Logical Replication and table bloat
Date
Msg-id 9ff805fa-85b0-28b9-44e6-1130a2f14f9d@aklaver.com
Whole thread Raw
In response to Logical Replication and table bloat  (Martín Fernández <fmartin91@gmail.com>)
List pgsql-general
On 6/5/20 12:53 PM, Martín Fernández wrote:
> Hello,
> 
> Yesterday we stumbled upon a performance issue that we were not expecting. We are replicating our database using AWS
DMSwhich uses logical replication to capture changes. We have some hot tables that get updated very regularly and with
theDMS turned on we started noticing that in those table, table bloat increased considerably ~15 times more free_tuples
thanthe average.
 
> 
> When doing logical replication, the subscriber will hold the tuples that could be flagged for reuse until they are
sent? Just trying to understand a little bit better how the logical replication is affecting the vacuuming.
 

A question for the AWS folks:

https://forums.aws.amazon.com/forum.jspa?forumID=60

> 
> Thanks before hand!
> 
> Best,
> Martín
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment
Next
From: Peter Eisentraut
Date:
Subject: Re: Logical Replication and table bloat