Re: PG12: Any drawback of increasing wal_keep_segments - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PG12: Any drawback of increasing wal_keep_segments
Date
Msg-id 202203241025.qygop5cr3qw7@alvherre.pgsql
Whole thread Raw
In response to PG12: Any drawback of increasing wal_keep_segments  ("Shukla, Pranjal" <pshukla@akamai.com>)
Responses Re: PG12: Any drawback of increasing wal_keep_segments
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected zero results
Next
From: Oskar Stenberg
Date:
Subject: Get primary key of a table through SPI