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

From Andres Freund
Subject Re: One long transaction or multiple short transactions?
Date
Msg-id 20151017171338.GB28038@awork2.anarazel.de
Whole thread Raw
In response to Re: One long transaction or multiple short transactions?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: One long transaction or multiple short transactions?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-performance
On 2015-10-17 10:26:01 -0500, Jim Nasby wrote:
> Except inserts *do* take a lot of locks, just not user-level locks.
> Operations like finding a page to insert into, seeing if that page is in
> shared buffers, loading the page into shared buffers, modifying a shared
> buffer, getting the relation extension lock if you need to add a new page.
> Then there's a whole pile of additional locking you could be looking at for
> inserting into any indexes.
>
> Now, most of the locks I described up there are transaction-aware

Missing *not*?


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: One long transaction or multiple short transactions?
Next
From: Jim Nasby
Date:
Subject: Re: One long transaction or multiple short transactions?