Re: Estimating wal_keep_size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Le sam. 19 juin 2021 à 02:13, Dean Gibson (DB Administrator) <postgresql@xxxxxxxxxxx> 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. 

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux