Michael, thanks for your answer.
Looks like it is not my case because issue is reproducible also for table with
100% single writer backend. Also as it was mentioned whole system gets hung.
Regards,
Pavel Suderevsky
From: MichaelDBA
Sent: Friday, March 16, 2018 16:42
To: Pavel Suderevsky
Cc
on_locked=0 sleep_on_page=0 get_request=0
sleep_on_buffer=0
14:33:55 TOTAL=7 wait_transaction_locked=0 sleep_on_page=0 get_request=0
sleep_on_buffer=0
I understand that RAID-6 is not the best option, but I can't catch any evidence
telling that system run out of 1GB RAID controller cache on
Hi,
I have an issue with sporadic slow insert operations with query duration
more than 1 sec while it takes about 50ms in average.
Configuration:
OS: Centos 7.2.151
PostgreSQL: 9.6.3
CPU: Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GHz
Memory: totalusedfree shared buf
