Re: One long transaction or multiple short transactions?

Поиск
Список
Период
Сортировка
От Graeme B. Bell
Тема Re: One long transaction or multiple short transactions?
Дата
Msg-id 884892BF-DD42-4E0A-8973-3A691E25E450@skogoglandskap.no
обсуждение исходный текст
Ответ на Re: One long transaction or multiple short transactions?  (Laurent Martelli <laurent.martelli@enercoop.org>)
Ответы Re: One long transaction or multiple short transactions?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список 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 по дате отправления:

Предыдущее
От: Laurent Martelli
Дата:
Сообщение: Re: One long transaction or multiple short transactions?
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4