How Many Inserts Per Transactions

Поиск
Список
Период
Сортировка
От Trevor Astrope
Тема How Many Inserts Per Transactions
Дата
Msg-id Pine.LNX.4.44.0308051155100.14944-100000@gord.tabbweb.com
обсуждение исходный текст
Ответы Re: How Many Inserts Per Transactions  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: How Many Inserts Per Transactions  (Hannu Krosing <hannu@tm.ee>)
Список pgsql-performance
I was wondering if anyone found a sweet spot regarding how many inserts to
do in a single transaction to get the best performance? Is there an
approximate number where there isn't any more performance to be had or
performance may drop off?

It's just a general question...I don't have any specific scenario, other
than there are multiple backends doing many inserts.

Thanks,

Trevor


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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Some vacuum & tuning help
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Some vacuum & tuning help