Re: One long transaction or multiple short transactions?

From: "Graeme B(dot) Bell" <graeme(dot)bell(at)nibio(dot)no>
To: Laurent Martelli <laurent(dot)martelli(at)enercoop(dot)org>, "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: One long transaction or multiple short transactions?
Date: 2015-10-09 08:33:21
Message-ID: 884892BF-DD42-4E0A-8973-3A691E25E450@skogoglandskap.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2015-10-09 13:01:53 Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4
Previous Message Laurent Martelli 2015-10-09 06:45:28 Re: One long transaction or multiple short transactions?