Re: Transaction Size in PostgreSQL

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: Transaction Size in PostgreSQL
Дата
Msg-id 5681E7B8-DCF4-48B6-B32F-6895670BB000@crazybean.net
обсуждение исходный текст
Ответ на Re: Transaction Size in PostgreSQL  (Thomas Kellerer <shammat@gmx.net>)
Список pgsql-admin

On Dec 7, 2021, at 1:41 AM, Thomas Kellerer <shammat@gmx.net> wrote:

"Massive data changes" in a single transaction aren't really a problem.
In my experience a single transaction changing a lot of rows is more
efficient than multiple transactions changing fewer rows.

That might work on a idle system but I would have to disagree with that statement.  In theory it may be more efficient but it practice large long running transactions cause replication lag issues as well as vacuuming issues by holding on to older xmin value.  Basically, they are bad for high transaction systems.  





В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Transaction Size in PostgreSQL
Следующее
От: Firthouse banu
Дата:
Сообщение: Pg_dump