Re: Fork-based version of pgbench

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fork-based version of pgbench
Дата
Msg-id 17376.1133472886@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Fork-based version of pgbench  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Fork-based version of pgbench  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Список pgsql-patches
Argh, I'm an idiot ... a big part of the problem with the original
fork-based pgbench is that I'd rearranged the startup code without
noticing a data dependency.  You can't initialize the default scripts
until you've gotten the correct value of "tps" by inspecting the
database.  What was happening was that it was making tps = 1 always,
which meant that every transaction tried to update the bid = 1 row
of "branches", which resulted in strict serialization of transactions.
Performance of the attached version is markedly better ;-)

            regards, tom lane


Вложения

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

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: Case Conversion Fix for MB Chars
Следующее
От: Joachim Wieland
Дата:
Сообщение: TODO-Item: include for guc