Logical Replication and table bloat

Поиск
Список
Период
Сортировка
От Martín Fernández
Тема Logical Replication and table bloat
Дата
Msg-id 960E21B1-2AE7-49EE-B9F5-6FD9AD00C366@gmail.com
обсуждение исходный текст
Ответы Re: Logical Replication and table bloat
Re: Logical Replication and table bloat
Список pgsql-general
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. 

Thanks before hand!

Best,
Martín


В списке pgsql-general по дате отправления:

Предыдущее
От: Paul van der Linden
Дата:
Сообщение: Re: Possible improvement
Следующее
От: Ron
Дата:
Сообщение: Re: Oracle vs. PostgreSQL - a comment