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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication: slave server has 3x size of production server?
Date: 2020-02-22 17:33:37
Message-ID: 98f036e0-9bf2-8798-8742-9dba0601fb9a@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/22/20 9:25 AM, Edson Richter wrote:
> 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?

How are you measuring the sizes?

Where is the space being taken up on disk?

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-02-22 17:34:40 Re: Shared buffer hash table corrupted
Previous Message Mark Fletcher 2020-02-22 17:28:58 Re: Shared buffer hash table corrupted