Postgres logical replication: db table grows indefinitely

Question

I have a postgres table (300Mb size) which is logically replicated to another server. Until I've made some changes everything was perfectly good. Then master started to grow (up to 2,5 Gb at rate 15 mb at 5 minutes roughly). I tried to tune WAL settings and do a WAL cleanup, but it didn't help.

What I have done before this issue was discovered:

Rebuilt a materialized view dependent on master table a lot of times (and it is a heavy CPU consuming operation)
Added a new column on master table and slave table
Added a rule on inserts (copy a value from jsonfield to charfield)

What could have caused this issue?

Is replication still working? Look at the standby logs. Perhaps you broke replication, and WAL has to be retained until you fix it. — Laurenz Albe
– Laurenz Albe, Commented Aug 14, 2020 at 11:20

maremare · Accepted Answer · 2020-08-29 15:25:33Z

1

I'm still unsure what caused the issue, but probably it was adding a new column. After restoring a backup and recreating publication and subscription everything worked pretty good.

answered Aug 29, 2020 at 15:25

maremare

4441 gold badge5 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres logical replication: db table grows indefinitely

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related