PostgreSQL存储引擎多线程化的研究与实现

Research and Implementation of Multi-threaded PostgreSQL Storage Engine

为解决PostgreSQL数据库系统启动很多进程占用大量系统资源的问题,提出一种改进PostgreSQL存储引擎的方法,即采用线程池,使用主线程唤醒线程池中的子线程方法替代PostgreSQL原有的多进程通讯机制,从而解决PostgreSQL数据库大量进程占用大量系统资源的弊端。实验表明PostgreSQL存储引擎的线程池的改进方法,能够很好地解决系统资源占用的问题,提高了数据库的执行效率。

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 efiiciency of data-base.