Make a 100_bugs.pl test more faster.
Anton A. Melnikov <aamelnikov@inbox.ru>
From: "Anton A. Melnikov" <aamelnikov@inbox.ru>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-11-16T14:41:16Z
Lists: pgsql-hackers
Attachments
- v1-0001-Reuse-nodes-in-100_bugs-test.patch (text/x-patch) patch v1-0001
- 100_bugs-CPU-usage.txt (text/plain)
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
Commits
-
Shave some cycles off subscription/t/100_bugs.pl tests.
- fccaf259f22f 16.0 landed