Re: [PERFORM] One long transaction or multiple short transactions?

2015-10-09 Thread Graeme B. Bell
> 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

Re: [PERFORM] One long transaction or multiple short transactions?

2015-10-09 Thread Laurent Martelli
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

Re: [PERFORM] Re: Multi processor server overloads occationally with system process while running postgresql-9.4

2015-10-09 Thread Kevin Grittner
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