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 DMS which uses logical replication to
capture changes. We have some hot tables that get updated very regularly and
with the DMS turned on we started noticing that in those table, table bloat
increased considerably ~15 times more free_tuples than the 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.kla...@aklaver.com