: pgsql-performa...@postgresql.org
Subject: Re: PG 9.6 Slow inserts with long-lasting LWLocks
Sporadic insert slowness could be due to lock delays (locktype=extend) due to
many concurrent connections trying to insert into the same table at the same
time. Each insert request may result in an extend
Sporadic insert slowness could be due to lock delays (locktype=extend)
due to many concurrent connections trying to insert into the same table
at the same time. Each insert request may result in an extend lock (8k
extension), which blocks other writers. What normally happens is the
these extend
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