Estimating wal_keep_size

Поиск
Список
Период
Сортировка
От Dean Gibson (DB Administrator)
Тема Estimating wal_keep_size
Дата
Msg-id 471a6e7d-928e-c899-bf9f-341ae79b04ea@mailpen.com
обсуждение исходный текст
Ответы Re: Estimating wal_keep_size
Re: Estimating wal_keep_size
Список pgsql-performance
Is this reasonable thinking?

I'd think that one would want a wal_keep_size to cover the pending updates while the standby server might be unavailable, however long one might anticipate that would be.

In my case, I get a complete replacement (in the form of "|"- delimited ASCII files) of one of the SCHEMAs every Sunday.  The size of that ASCII data is about 2GB, so I'm thinking of doubling that to 4GB (256 WAL files) to protect me in the case of the standby being unavailable during the update.  Note that a complete loss of both servers is not catastrophic (I have backups);  it would just be annoying.

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

Предыдущее
От: "Dean Gibson (DB Administrator)"
Дата:
Сообщение: Re: PostgreSQL V13 Replication Issue
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Estimating wal_keep_size