Based On Postgresql Buffer Pool Adaptive Configuration Design And Implementation

An autonomic database management system is a self tuning, self optimizing, self-healing and self protecting database management system(DBMS). Since expert database administrators(DBAs)are scarce, introducing a DBMS that is self tuning will decrease the total cost of ownership of the system. In this thesis we present a first step to incorporating self tuning capabilities in the PostgreSQL DBMS.The buffer area is the main memory management area of the DBMS. Effective use of this area ensures efficiency of the DBMS. Some DBMSs split the buffer area into multiple buffer pools and this has led to performance increases in some cases.Once multiple buffer pools are supported it is up to the DBA to size them based on each of their needs. Optimal sizing leads to good performance, therefore, as the workload changes the DBA has to adjust the sizes of the buffer pools.We extend PostgreSQL to support multiple buffer pools. We remove the dependency on the DBA and automatically adjust the sizes of the buffer pools to changes in the environment. In this paper, first we introduced the related knowledge about autonomic compute; self-configuring of database management system, and introduce more knowledge about Multiple Buffer Pools in this paper; we also analysis the possibilities of using PostgreSQL. We studied and design many algorithms about multiple buffer pool. Then we used the sizing algorithm and design and implementation for integration of multiple buffer pools in PostgreSQL. And design of dynamic resizing of buffer pools in PostgreSQL; Finally, we run the TPC-B workload comparing the original version of PostgreSQL with modified PostgreSQL by the specific experiment, observe the changes of throughput, to validate our result.