Re: One long transaction or multiple short transactions? - Mailing list pgsql-performance

From Graeme B. Bell
Subject Re: One long transaction or multiple short transactions?
Date
Msg-id 884892BF-DD42-4E0A-8973-3A691E25E450@skogoglandskap.no
Whole thread Raw
In response to Re: One long transaction or multiple short transactions?  (Laurent Martelli <laurent.martelli@enercoop.org>)
Responses Re: One long transaction or multiple short transactions?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-performance
> I don't think inserts can cause contention on the server. Insert do not lock tables during the transaction. You may
havecontention on sequence but it won't vary with transaction size. 

Perhaps there could be a trigger on inserts which creates some lock contention?




pgsql-performance by date:

Previous
From: Laurent Martelli
Date:
Subject: Re: One long transaction or multiple short transactions?
Next
From: Kevin Grittner
Date:
Subject: Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4