PostgreSQL database performance optimization
Wang, Qiang (2011)
Wang, Qiang
HAAGA-HELIA ammattikorkeakoulu
2011
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201105198674
https://urn.fi/URN:NBN:fi:amk-201105198674
Tiivistelmä
The thesis was request by Marlevo software Oy for a general description of the PostgreSQL database and its performance optimization technics. Its purpose was to help new PostgreSQL users to quickly understand the system and to assist DBAs to improve the database performance.
The thesis was divided into two parts. The first part described PostgreSQL database optimization technics in theory. In additional popular tools were also introduced. This part was based on PostgreSQL documentation, relevant books and other online resources. The second part demonstrates the optimization process in practice with 3 test cases. Each case was created from a different aspect.
The thesis concludes PostgreSQL database optimization is different from others. Users should have enough knowledge about it before performing database optimization tasks. Especially for those who come from SQL server and DB2 world.
The thesis was divided into two parts. The first part described PostgreSQL database optimization technics in theory. In additional popular tools were also introduced. This part was based on PostgreSQL documentation, relevant books and other online resources. The second part demonstrates the optimization process in practice with 3 test cases. Each case was created from a different aspect.
The thesis concludes PostgreSQL database optimization is different from others. Users should have enough knowledge about it before performing database optimization tasks. Especially for those who come from SQL server and DB2 world.