Title
Autonomic buffer pool configuration in PostgreSQL
Abstract
As database management systems (DBMSs) continue to expand into new application areas, the complexity of the systems and the diversity of database workloads are increasing. Managing the performance of DBMSs via manual adjustment of resource allocations in this new environment has become impractical. Autonomic DBMSs shift the responsibility for performance management onto the systems themselves. This paper serves as a proof of concept, illustrating how autonomic principles can be applied to a DBMS to provide automatic sizing of buffer pools, a key resource in a DBMS. We describe an implementation of our autonomic system in PostgreSQL, an open source database management system, and provide a set of experiments that verify our approach.
Year
DOI
Venue
2005
10.1109/ICSMC.2005.1571121
Systems, Man and Cybernetics, 2005 IEEE International Conference
Keywords
Field
DocType
SQL,buffer storage,public domain software,relational databases,resource allocation,PostgreSQL,autonomic buffer pool configuration,open source database management system,performance management,resource management,Autonomic Computing,Database Management Systems,buffer pool configuration,performance,resource management
SQL,Relational database,Computer science,Proof of concept,Resource allocation,Sizing,Performance management,Database,Public domain software
Conference
Volume
ISSN
ISBN
1
1062-922X
0-7803-9298-1
Citations 
PageRank 
References 
1
0.35
8
Authors
4
Name
Order
Citations
PageRank
Wendy Powley132928.43
patrick martin214818.22
Nailah Ogeer310.35
Wenhu Tian4222.42