Re: One long transaction or multiple short transactions?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: One long transaction or multiple short transactions?
Дата
Msg-id 20151017171338.GB28038@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: One long transaction or multiple short transactions?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: One long transaction or multiple short transactions?
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: One long transaction or multiple short transactions?
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: One long transaction or multiple short transactions?