'openGauss performance reproduce

The openGauss is said to be 1.5M tpmC on 2-socket Kunpeng server. But how can I reproduce the results step by step?



Solution 1:[1]

Of course, but you should tune the performance for a while. I am afraid most of us don't have enough time to tune the optimal performance. Thus, the performance we test is probably a little lower than reported. But I consider that is reasonable. If you want to test the performance, like the following:

  1. Prepare an openGauss cluster that could run the TPC-C benchmark and store a proper data size; Note that the machines must be Kunpeng CPU. Otherwise, the performance will discount.
  2. Tune the knobs for the openGauss cluster. Typically, these knobs should be tuned: shared_buffers, work_mem, random_page_cost (~1 is better on SSD). Most of the resource parameters are bigger the better;
  3. Run the benchmark and wait for the result; Warm-up is better.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Wotchin