> I don't think inserts can cause contention on the server. Insert do not lock
> tables during the transaction. You may have contention on sequence but it
> won't vary with transaction size.
Perhaps there could be a trigger on inserts which creates some lock contention?
--
Sent via
Le 08/10/2015 01:40, Carlo a écrit :
>> How many cores do you have on that machine?
Test if limiting number of simultaneous feeds, like bringing their
number down to half of your normal connections has the same positive
effect.
<<
I am told 32 cores on a LINUX VM. The operators have
On Saturday, October 3, 2015 4:36 AM, ajaykbs wrote:
> version: Postgresql-9.4
> Hardware: HP DL980 (8-processor, 80 cores w/o hyper threading, 512GB RAM)
> Operating system: Red Hat Enterprise Linux Server release 6.4 (Santiago)
> uname -a : Linux host1