why autocommit mode is slow?

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема why autocommit mode is slow?
Дата
Msg-id BANLkTinvQ4z8pE95e-RVnBXngvORss7zpw@mail.gmail.com
обсуждение исходный текст
Ответы Re: why autocommit mode is slow?  (Dann Corbit <DCorbit@connx.com>)
Re: why autocommit mode is slow?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: why autocommit mode is slow?  (Craig Ringer <craig@postnewspapers.com.au>)
Re: why autocommit mode is slow?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: why autocommit mode is slow?  (Vick Khera <vivek@khera.org>)
Re: why autocommit mode is slow?  (Simon Riggs <simon@2ndQuadrant.com>)
Re: why autocommit mode is slow?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
Дерево обсуждения
Hi,
this is maybe a stupid question, but I don't know how to explain to my coworkers why performing many inserts in autocommit mode is so much slower than making all of them in one transaction.

Why is that so slow?

regards
Szymon

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

Предыдущее
От: Yang Zhang
Дата:
Сообщение: Re: What happened to ALTER SCHEMA ... SET TABLESPACE?
Следующее
От: Dann Corbit
Дата:
Сообщение: Re: why autocommit mode is slow?