Re: Estimating wal_keep_size - Mailing list pgsql-performance

From Julien Rouhaud
Subject Re: Estimating wal_keep_size
Date
Msg-id CAOBaU_a-BanEBN=5cP8UP92Cw7Yst-okmHYi9o1hYU9ZfuASHA@mail.gmail.com
Whole thread Raw
In response to Re: Estimating wal_keep_size  ("Dean Gibson (DB Administrator)" <postgresql@mailpen.com>)
Responses Re: Estimating wal_keep_size  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List pgsql-performance
Le sam. 19 juin 2021 à 02:13, Dean Gibson (DB Administrator) <postgresql@mailpen.com> a écrit :

Granted, but the same question arises about the value for max_slot_wal_keep_size.  Setting either too low risks data loss, & setting either too high results in unnecessary disk space used.  The question was, is the estimated VALUE reasonable under the circumstances?

it may be, until one day it won't be. and that day usually happens. when you set up this kind of limit you choose service availability over your data, so you have to accept that it may not be enough. if this is a problem don't setup a limit. 

pgsql-performance by date:

Previous
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: Estimating wal_keep_size
Next
From: Vijaykumar Jain
Date:
Subject: Re: Estimating wal_keep_size