Postgresql的TPM实现和改进

Implementation and Improvement of TPM for Postgresql

传统的DBMS的性能随着连接数的增加会降低,而且商业的DBMS由于昂贵的价格而不适用于一般用户。虽然Postgresql性能逊于商业DBMS,但是其性价比更高。文中旨在提高Postgresql的性能,在传统的服务器和客户之间增加TPM,并增加对服务器的监测功能以及实现动态改变服务器和客户间的连接数。由于最佳连接数取决于服务器的负载状况,因此文中设计不同连接数的TPM来分析服务器状态。实验使用TPC-C标准,结果证明,该方法能有效提高Postgresql的性能,规定时间内的吞吐量有所增加,响应时间有所减小。

The performance of traditional DBMS will decrease when connection numbers between server and client increase. And file com- mereial DBMS is not widely used because of its expensive price. Though Postgresql has a part inferior to commercial DBMS on perforln- ance side, it has higher cost efficient. The objective is to realize high performance and reliability in DBMS. And propose a new way by adding TPM between server and client. The key points are the function to detect the server state and change the connection numbers dy- namically. But the best connection number depends on the load state of server, so design TPM in various points to analyze server state. Use TPC-C benchmark in this test,and the results prove the effectiveness,and the throughout is bigger and responding time is shorter.