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

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Replication: slave server has 3x size of production server?
Дата
Msg-id MN2PR01MB53275B5A45E7D752514934CECFEE0@MN2PR01MB5327.prod.exchangelabs.com
обсуждение исходный текст
Ответы Re: Replication: slave server has 3x size of production server?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Reset DB stats suggestion pg_stat_reset()
Следующее
От: Mark Fletcher
Дата:
Сообщение: Re: Shared buffer hash table corrupted