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?
Список 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 по дате отправления: