Sintonia em banco de dados através do particionamento de tabelas

Abstract

The tuning of the database is the process that aims to improve performance in database systems. This practice has several aspects and methods to consider, among these, there is the partitioning of tables that contributes to the performance and administration of a database table by segmenting into smaller slices, providing a lower access time and maintenance. Objective of this work, is a study of the application partitioning as a technique for tuning. Pair this, it was necessary to review the literature to contextualize the topic, as well as study tools such as management system PostgreSQL database to assist in the preparation of experiments. In all, three experiments were performed aiming at the comparative performance between partitioned and nonpartitioned tables. To achieve these, scenarios were developed and used tools for population of the tables with test data. The experiments allowed us to verify cases where there is performance gain when the partitioning strategy is verified.