hammerDB中的postgresql基准测试

Question

我正在尝试对后缀进行测试，使其低于以下错误：

Vuser 1:Checkpoint and Vacuum
Error in Virtual User 1: ERROR:  must be superuser to do CHECKPOINT
Vuser 1:FINISHED FAILED
Vuser 13:FINISHED SUCCESS
Vuser 18:FINISHED SUCCESS
Vuser 8:FINISHED SUCCESS
Vuser 5:FINISHED SUCCESS
Vuser 21:FINISHED SUCCESS
Vuser 9:FINISHED SUCCESS
Vuser 16:FINISHED SUCCESS
Vuser 20:FINISHED SUCCESS
Vuser 6:FINISHED SUCCESS
Vuser 14:FINISHED SUCCESS
Vuser 19:FINISHED SUCCESS
Vuser 11:FINISHED SUCCESS
Vuser 15:FINISHED SUCCESS
Vuser 17:FINISHED SUCCESS
Vuser 7:FINISHED SUCCESS
Vuser 3:FINISHED SUCCESS
Vuser 10:FINISHED SUCCESS
Vuser 12:FINISHED SUCCESS
Vuser 2:FINISHED SUCCESS
Vuser 4:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
runtimer returned after 416 seconds
vudestroy success
TEST SEQUENCE COMPLETE

任何解决此问题的建议，以及要映射为超级用户的用户。

Answer 1

您可以使用以下命令在测试结束时禁止HammerDB调用检查点和真空：

hammerdb>diset tpcc pg_vacuum false
Changed tpcc:pg_vacuum from true to false for PostgreSQL

如果在PostgreSQL上运行长时间运行或多次测试，建议启用自动真空，以确保在测试期间正在进行真空，以防止膨胀。当启用自动真空时，不需要手动进行。