one transaction or multiple inserts?

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема one transaction or multiple inserts?
Дата
Msg-id 3D9C08D7.6020700@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: one transaction or multiple inserts?
Список pgsql-general
When inserting a lot of data into a DB which would be faster, doing all
the inserts in one transaction or doing multiple inserts?

And more importantly, why? :)

I'M assuming that each insert is in fact a transaction and doing, for
example, 1000 inserts is the same as doing 1000 transaction. But if I
put them all in one transaction, it would be equivalent to doing (duh) 1
transaction.

Thanks,

Jc


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: foreach in sql functions
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: one transaction or multiple inserts?