Replication: slave server has 3x size of production server?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Replication: slave server has 3x size of production server?
Date: 2020-02-22 17:25:08
Message-ID: MN2PR01MB53275B5A45E7D752514934CECFEE0@MN2PR01MB5327.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I've a database cluster created at 9.6.10 linux x64 server rhel. I made progressive upgrades, first upgrading slave and then upgrading master.
Actually both are running 9.6.17.
Current production server has 196Gb in size.
Nevertheless, the replicated (slave) server has 598 Gb in size.
Replication server has 3x size of production server, is that normal?

Shall I drop the slave server and re-create it? How to avoid this situation in future?

Thanks,

Edson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Fletcher 2020-02-22 17:28:58 Re: Shared buffer hash table corrupted
Previous Message Adrian Klaver 2020-02-22 17:17:18 Re: Reset DB stats suggestion pg_stat_reset()