Re: Savepoints in transactions for speed?

Поиск
Список
Период
Сортировка
От Mike Blackwell
Тема Re: Savepoints in transactions for speed?
Дата
Msg-id CANPAkgt2A2YnnGV_kmq9wVpZHaSLg2KrZdK+6e6K8Vu3j2Lc+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Savepoints in transactions for speed?  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: Savepoints in transactions for speed?  (Willem Leenen <willem_leenen@hotmail.com>)
Список pgsql-performance


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

Предыдущее
От: Willem Leenen
Дата:
Сообщение: Re: Optimize update query
Следующее
От: Willem Leenen
Дата:
Сообщение: Re: Savepoints in transactions for speed?