RE: PG 9.6 Slow inserts with long-lasting LWLocks

2018-03-15 Thread Pavel Suderevsky
Hi, Well, unfortunately I still need community help. -- Environment OS: Centos CentOS Linux release 7.2.1511 Kernel: 3.10.0-327.36.3.el7.x86_64 PostgreSQL: 9.6.3 -- Hardware Server: Dell PowerEdge R430 CPU: Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GHz Raid controller: PERC H730 Mini (1GB cache) Di

Re: Too many .history file in pg_xlog takes lots of space

2018-03-15 Thread 彭昱傑
Hi Michael, Alvaro, Tom: Really appreciate yours help, this is an invalid report, and I'm sorry for that. After I examine restart script, I found we generate recovery.conf every time, and this cause lost of timeline. Thanks. 2018-03-14 23:29 GMT+08:00 Tom Lane : > Alvaro Herrera writes: > >