Re: Savepoints in transactions for speed?

Поиск
Список
Период
Сортировка
От Willem Leenen
Тема Re: Savepoints in transactions for speed?
Дата
Msg-id DUB104-W3775F9EFC7F49ED475B188F5D0@phx.gbl
обсуждение исходный текст
Ответ на Re: Savepoints in transactions for speed?  (Mike Blackwell <mike.blackwell@rrd.com>)
Список pgsql-performance

Commitmarks are written to disk after each transaction. So transactionsize has impact on performance.


Date: Wed, 28 Nov 2012 09:18:20 -0600
Subject: Re: [PERFORM] Savepoints in transactions for speed?
From: mike.blackwell@rrd.com
To: klaussfreire@gmail.com
CC: pgsql-performance@postgresql.org



On Tue, Nov 27, 2012 at 7:16 PM, Claudio Freire <klaussfreire@gmail.com> wrote:
Updates, are faster if batched, if your business logic allows it,
because it creates less bloat and creates more opportunities for with
HOT updates. I don't think it applies to inserts, though, and I
haven't heard it either.

Ah.  That must have been what I'd half-remembered.  Thanks for the clarification.

Mike 

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

Предыдущее
От: Mike Blackwell
Дата:
Сообщение: Re: Savepoints in transactions for speed?
Следующее
От: Niels Kristian Schjødt
Дата:
Сообщение: Re: Optimize update query