Thank you, Justin Pryzby.
I reset shared_buffer to 16GB,and the memory usage of checkpoint and
recovering just stayed at 16GB.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
192956 postgres 20 0 18.5g 16g 16g S 1.3 25.9 19:44.69 postgres:
startup process recover
Hi,
On 2017-11-03 01:43:32 +, tao tony wrote:
> I had an asynchronous steaming replication HA cluster.Each node had 64G
> memory.pg is 9.6.2 and deployed on centos 6.
>
>
> Last month the database was killed by OS kernel for OOM,the checkpoint
> process was killed.
>
>
> I noticed checkp
On Fri, Nov 03, 2017 at 01:43:32AM +, tao tony wrote:
> I had an asynchronous steaming replication HA cluster.Each node had 64G
> memory.pg is 9.6.2 and deployed on centos 6.
>
> Last month the database was killed by OS kernel for OOM,the checkpoint
> process was killed.
If you still have l
