Make a 100_bugs.pl test more faster.

Поиск
Список
Период
Сортировка
От Anton A. Melnikov
Тема Make a 100_bugs.pl test more faster.
Дата
Msg-id eb7aa992-c2d7-6ce7-4942-0c784231a362@inbox.ru
обсуждение исходный текст
Ответы Re: Make a 100_bugs.pl test more faster.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello!

The previous discussion was here:
https://www.postgresql.org/message-id/flat/b570c367-ba38-95f3-f62d-5f59b9808226%40inbox.ru

>On 15.11.2022 04:59, Tom Lane wrote:
>> "Anton A. Melnikov" <aamelnikov@inbox.ru> writes:
>> 
>> Additionally
>> i've tried to reduce overall number of nodes previously
>> used in this test in a similar way.
> 
> Optimizing existing tests isn't an answer to that.  We could
> install those optimizations without adding a new test case.

Here is a separate patch for the node usage optimization mentioned above.
It decreases the CPU usage during 100_bugs.pl by about 30%.

There are also some experimental data: 100_bugs-CPU-usage.txt


Would be glad for any comments and concerns.

With best regards,

-- 
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Вложения

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

Предыдущее
От: Ted Yu
Дата:
Сообщение: Re: closing file in adjust_data_dir
Следующее
От: Tom Lane
Дата:
Сообщение: Re: const qualifier for list APIs