Adaptive Machine Learning Techniques for PostgreSQL Performance Optimization: A PostgreSQL Case Study

Sangeetha Mandapaka ()

International Journal of Innovative Science and Research Technology (IJISRT), 2025, vol. 10, issue 10, 3375-3381

Abstract: This article presents a framework for integrating advanced machine learning models within PostgreSQL to optimize query performance and manage workloads dynamically. The integration creates a paradigm shift from static, rulebased optimization to adaptive, data-driven approaches that respond to changing conditions. PostgreSQL's extensible architecture provides an ideal foundation for implementing ML-enhanced components without modifying core database code. The framework encompasses four key areas: query optimizer enhancement using gradient boosting and neural networks, adaptive indexing mechanisms that automatically adjust to workload patterns, dynamic resource allocation through workload classification and forecasting, and a comprehensive model training pipeline. Experimental evaluations across analytical, transactional, and hybrid workloads demonstrate significant improvements in cardinality estimation accuracy, execution plan quality, resource utilization, and administrative overhead reduction. The modular design enables incremental adoption in production environments while maintaining compatibility with existing applications, illustrating how traditional relational database systems can evolve to meet modern data challenges through machine learning integration.

Keywords: Machine Learning Integration; PostgreSQL Extensibility; Adaptive Query Optimization; Workload Management; Learned Index Structures. (search for similar items in EconPapers)
Date: 2025
References: Add references at CitEc
Citations:

Downloads: (external link)
https://www.ijisrt.com/adaptive-machine-learning-t ... ostgresql-case-study (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:cvr:ijisrt:2025:10:ijisrt25oct1435

DOI: 10.38124/ijisrt/25oct1435

Access Statistics for this article

More articles in International Journal of Innovative Science and Research Technology (IJISRT) from IJISRT Publication
Bibliographic data for series maintained by Rahul Goyel ().