Features of List Partitioning Application in the PostgreSQL DBMS

As the volume of data processed in information systems increases, there is a growing need to use methods that ensure scalability, high performance, and efficient administration. One such method is table partitioning, which involves the logical division of data into independent segments. This process has been shown to optimize query execution and simplify the management of large tables. Purpose: to examine the particulars of employing list partitioning within the PostgreSQL database management system and to assess its effect on the performance of SQL queries. Results: the theoretical foundations of list partitioning, its syntactic implementation and limitations have been presented. A comparative experiment was conducted that demonstrated an enhancement in productivity when employing partitioning as opposed to a monolithic table. Typical scenarios of using the method when working with categorized data have been described. Practical significance: the efficiency of query processing and administration of large tables in PostgreSQL can be enhanced through the rational design of the data storage structure using list partitioning.