Re: PG12: Any drawback of increasing wal_keep_segments

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PG12: Any drawback of increasing wal_keep_segments
Дата
Msg-id 202203241025.qygop5cr3qw7@alvherre.pgsql
обсуждение исходный текст
Ответ на PG12: Any drawback of increasing wal_keep_segments  ("Shukla, Pranjal" <pshukla@akamai.com>)
Ответы Re: PG12: Any drawback of increasing wal_keep_segments  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
On 2022-Mar-22, Shukla, Pranjal wrote:

> Team,
> Are there any disadvantages of increasing the “wal_keep_segments” to a
> higher number say, 500? Will it have any impact on performance of
> streaming replication, on primary or secondary servers?

No.  It just means WAL will occupy more disk space.  I've seen people go
even as high as 5000 with no issues.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected zero results
Следующее
От: Oskar Stenberg
Дата:
Сообщение: Get primary key of a table through SPI