Re: Inserts optimization?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Inserts optimization?
Дата
Msg-id 26312.1145459692@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Inserts optimization?  ("Magnus Hagander" <mha@sollentuna.net>)
Список pgsql-performance
"Magnus Hagander" <mha@sollentuna.net> writes:
>>> Actually, [commit_delay] might well hurt by introducing extra delays.
>>
>> Well, if you read the documentation, you will see that it
>> will only wait if there are at least commit_siblings other
>> transactions active. So when Bacula serializes access, there
>> will be no delays, as there is only a single transaction alive.

> Hm. Right. Well, it still won't help :-)

It could actually hurt, because nonzero time is required to go look
whether there are any other active transactions.  I'm not sure whether
this overhead is enough to be measurable when there's only one backend
running, but it might be.

            regards, tom lane

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

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Inserts optimization?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Inserts optimization?