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 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11

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 pgsql-p