When large amounts of data are updated, the write-to load for the database will become great, and the multiplexing state may become unstable.
Accordingly, by editing the parameters below in the postgresql.conf file, a stable multiplexing state can be maintained. Refer to "Estimating Transaction Log Space Requirements" in the Installation and Setup Guide for Server for information on transaction log space requirements.
Parameter | Content |
|---|---|
wal_keep_segments | Refer to "6.3.2 Creating, Setting, and Registering the Primary Server Instance" for details. |
checkpoint_segments | The transaction log is written out according to the checkpoint trigger. If a transaction log with the capacity of the value specified in this parameter is generated, the checkpoint will be executed. If a large value is specified in this parameter, the time required for crash recovery will increase. If a small value is specified in this parameter, many checkpoints will be generated, which will affect the performance of the applications that connect to the primary server. |
