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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Replication: slave server has 3x size of production server?
Дата
Msg-id 98f036e0-9bf2-8798-8742-9dba0601fb9a@aklaver.com
обсуждение исходный текст
Ответ на Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
Ответы RE: Replication: slave server has 3x size of production server?  (Edson Richter <edsonrichter@hotmail.com>)
Список 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.klaver@aklaver.com



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

Предыдущее
От: Mark Fletcher
Дата:
Сообщение: Re: Shared buffer hash table corrupted
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Shared buffer hash table corrupted