Our website uses cookies. By continuing to use this site, you agree to our use of cookies in accordance with this notice and the Terms of Use.
News
Submit manuscript
Intellectual Technologies on Transport
Journals / Intellectual Technologies on Transport / Issue 3, 2025 / Features of List Partitioning Application in the PostgreSQL DBMS
UDC
004.65 004.652.4
VAK Russia
2.3.5

FEATURES OF LIST PARTITIONING APPLICATION IN THE POSTGRESQL DBMS Features of List Partitioning Application in the PostgreSQL DBMS

Published in Intellectual Technologies on Transport · Pages 49–57 · Rubric: MATHEMATICAL AND SOFTWARE SUPPORT FOR COMPUTER COMPLEXES AND NETWORKS
DOI: https://doi.org/10.20295/2413-2527-2025-343-49-57 · EDN: IUUCHU
Received: 23.06.2025 Accepted: 07.08.2025 Published: 25.09.2025
Authors
AN
Andrey Zabrodin
NI
Nikita Sabirov
ABSTRACT
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.
KEYWORDS
data partitioning, PostgreSQL, list partitioning, performance, query optimization, indexing, data distribution, horizontal fragmentation, database architecture, big data
Text References
Text
Text (PDF)
Read Download

1. PostgreSQL 17 Documentation: Table Partitioning. Available at: http://www.postgresql.org/docs/17/ddl-partitioning.html (accessed: June 01, 2025).

2. List Partitioning, Mastering SQL Using PostgreSQL: Online Course. Available at: http://postgresql.itversity.com/05_partitioning_tables_and_indexes/03_list_partitioning.html (accessed: June 05, 2025).

3. Raghuwanshi R. How to Use Table Partitioning to Scale PostgreSQL, EDB Postgres Tutorials. Published online at January 24, 2023. Available at: http://www.enterprisedb.com/postgres-tutorials/how-use-table-partitioning-scale-postgresql (accessed: June 05, 2025).

4. PostgreSQL 17 Documentation: Index Types. Available at: http://www.postgresql.org/docs/current/indexes-types.html (accessed: June 01, 2025).

5. Soto C. PostgreSQL Table Partitioning: Boosting Performance and Management, HackerNoon. Published online at October 04, 2023. Available at: http://hackernoon.com/postgresql-table-partitioning-boosting-performance-and-management (accessed: June 07, 2025).

6. Fakirpure M. PostgreSQL Queries with Table Partitions, HostnExtra Learn. Updated January 27, 2024. Available at: http://hostnextra.com/learn/paths/postgresql/postgresql-queries-with-table-partitions (accessed: June 07, 2025).

7. Blackwood-Sewell J., Soto C. When to Consider Postgres Partitioning, TigerData. Published online at March 04, 2024. Available at: https://www.tigerdata.com/learn/when-to-consider-postgres-partitioning (accessed: June 05, 2025).

PDF Text JATS XML
The contact persons
Anatoly Khomonenko
Editor-in-Chief
Anatoly Khomonenko
khomon@mail.ru
Lesya Bozhko
Deputy Editor-in-Chief
Lesya Bozhko
Principal Contact
Maksim Orzhevsky
206@it-pgups.ru
Editorial Staff
Staff Editorial
itt-pgups@yandex.ru +7(812)457-86-06
1754
downloads
Crossref RINC RINC Science Index Cyberleninka RCSI
16+
© itt.editorum.ru
Agreement Personal data protection and processing policy Support Powered by Editorum, 2026 Instructions
Login or Create
* Forgot your password?