关键词: PostgreSQL, 数据库性能测试, 数据库性能优化, 多线程优化

Abstract: In order to solve the problem that the PostgreSQL starts many processes which takes up a lot of system resources, this paper presents an improved method for PostgreSQL storage engine, that is, using the thread pool wake-up call to replace the original PostgreSQL multi-process communication mechanism, so as to solve the problem that the PostgreSQL takes up a lot of system resources while starting large number of processes. Experimental results show that the improved method of PostgreSQL storage engine thread pool can be a good solution to the problems of system resources and improve the implementation efficiency of database.

Key words: PostgreSQL, database performance test, database performance optimization, multi-threaded optimization