Re: PG12: Any drawback of increasing wal_keep_segments

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: "Shukla, Pranjal" <pshukla(at)akamai(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PG12: Any drawback of increasing wal_keep_segments
Date: 2022-03-24 10:25:42
Message-ID: 202203241025.qygop5cr3qw7@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dilip Kumar 2022-03-24 11:36:07 Re: Support logical replication of DDLs
Previous Message Dilip Kumar 2022-03-24 10:02:01 Re: Support logical replication of DDLs