PostgreSQL Tuning for Cloud-Native Java: Connection Pooling vs. Reactive Drivers
DOI:
https://doi.org/10.22399/ijcesen.3479Keywords:
PostgreSQL Tuning , Java Microservices, Connection Pooling, Reactive Programming, Cloud-Native ArchitectureAbstract
With the transition of software development practices under the cloud-native principles, database connectivity is the key to developing scalable and high-performance Java applications. As a widely used and powerful open-source relational database, PostgreSQL officially supports well-known synchronization access and a newfangled reactive model. This article compares connection pooling and reactive driver strategies for handling PostgreSQL connections in a cloud-native Java environment. The test rigs described in this discussion are designed to use real experiments with containers, different workloads, and performance monitoring tools. Each model is evaluated based on how it affects core performance metrics, including throughput, latency, resource utilization, and fault tolerance. Using mature libraries like HikariCP, connection pooling is demonstrated to be effective in stable systems with moderate concurrency due to its ease of use and simplicity, which integrates with existing Java tooling. However, reactive drivers based on R2DBC benefit from the best scalability and performance in high-concurrency, event-driven, event-driven systems using non-blocking I/O and asynchronous execution. The article also discusses practical tuning strategies and implementation guidance that match PostgreSQL's process model. In addition, it outlines hybrid or transitional use cases where both models could be used. The findings are ultimately guidance for choosing and configuring the best fitting PostgreSQL connectivity approach for the everyday modern Java applications in today's fast changing cloud native landscapes.
References
[1] Abbott, M. L., & Fisher, M. T. (2016). Scalability Rules: Principles for Scaling Web Sites. Addison-Wesley Professional.
[2] Astyrakakis, N., Nikoloudakis, Y., Kefaloukos, I., Skianis, C., Pallis, E., & Markakis, E. K. (2019, September). Cloud-Native Application Validation & Stress Testing through a Framework for Auto-Cluster Deployment. In 2019 IEEE 24th International Workshop on Computer Aided Modeling and Design of Communication Links and Networks (CAMAD) (pp. 1-5). IEEE.
[3] Caschetto, R. (2024). An Integrated Web Platform for Remote Control and Monitoring of Diverse Embedded Devices: A Comprehensive Approach to Secure Communication and Efficient Data Management (Doctoral dissertation, Politecnico di Torino).
[4] Chavan, A. (2023). Managing scalability and cost in microservices architecture: Balancing infinite scalability with financial constraints. Journal of Artificial Intelligence & Cloud Computing, 2, E264. http://doi.org/10.47363/JAICC/2023(2)E264
[5] Chavan, A. (2024). Fault-tolerant event-driven systems: Techniques and best practices. Journal of Engineering and Applied Sciences Technology, 6, E167. https://doi.org/10.47363/JEAST/2024(6)E167
[6] Chinamanagonda, S. (2023). Cloud-native Databases: Performance and Scalability-Adoption of cloud-native databases for improved performance. Advances in Computer Sciences, 6(1).
[7] Dahlin, K. (2020). An evaluation of spring webflux: With focus on built in sql features.
[8] Davis, C. (2019). Cloud Native Patterns: Designing Change-Tolerant Software. Simon and Schuster.
[9] Dhanagari, M. R. (2024). MongoDB and data consistency: Bridging the gap between performance and reliability. Journal of Computer Science and Technology Studies, 6(2), 183-198. https://doi.org/10.32996/jcsts.2024.6.2.21
[10] Dhanagari, M. R. (2024). Scaling with MongoDB: Solutions for handling big data in real-time. Journal of Computer Science and Technology Studies, 6(5), 246-264. https://doi.org/10.32996/jcsts.2024.6.5.20
[11] Farshchi, M., Schneider, J. G., Weber, I., & Grundy, J. (2015, November). Experience report: Anomaly detection of cloud application operations using log and cloud metric correlation analysis. In 2015 IEEE 26th international symposium on software reliability engineering (ISSRE) (pp. 24-34). IEEE.
[12] Fogel, A., Fung, S., Pedrosa, L., Walraed-Sullivan, M., Govindan, R., Mahajan, R., & Millstein, T. (2015). A general approach to network configuration analysis. In 12th USENIX Symposium on Networked Systems Design and Implementation (NSDI 15) (pp. 469-483).
[13] Gkamas, T., Karaiskos, V., & Kontogiannis, S. (2022). Performance evaluation of distributed database strategies using docker as a service for industrial iot data: Application to industry 4.0. Information, 13(4), 190.
[14] Goel, G., & Bhramhabhatt, R. (2024). Dual sourcing strategies. International Journal of Science and Research Archive, 13(2), 2155. https://doi.org/10.30574/ijsra.2024.13.2.2155
[15] Isyaku, B., Bakar, K. A., Zahid, M. S. M., & Nura Yusuf, M. (2020). Adaptive and hybrid idle–hard timeout allocation and flow eviction mechanism considering traffic characteristics. Electronics, 9(11), 1983.
[16] Karwa, K. (2023). AI-powered career coaching: Evaluating feedback tools for design students. Indian Journal of Economics & Business. https://www.ashwinanokha.com/ijeb-v22-4-2023.php
[17] Karwa, K. (2024). The future of work for industrial and product designers: Preparing students for AI and automation trends. Identifying the skills and knowledge that will be critical for future-proofing design careers. International Journal of Advanced Research in Engineering and Technology, 15(5). https://iaeme.com/MasterAdmin/Journal_uploads/IJARET/VOLUME_15_ISSUE_5/IJARET_15_05_011.pdf
[18] Konneru, N. M. K. (2021). Integrating security into CI/CD pipelines: A DevSecOps approach with SAST, DAST, and SCA tools. International Journal of Science and Research Archive. Retrieved from https://ijsra.net/content/role-notification-scheduling-improving-patient
[19] Kumar, A. (2019). The convergence of predictive analytics in driving business intelligence and enhancing DevOps efficiency. International Journal of Computational Engineering and Management, 6(6), 118-142. Retrieved from https://ijcem.in/wp-content/uploads/THE-CONVERGENCE-OF-PREDICTIVE-ANALYTICS-IN-DRIVING-BUSINESS-INTELLIGENCE-AND-ENHANCING-DEVOPS-EFFICIENCY.pdf
[20] Luz, W. P., Pinto, G., & Bonifácio, R. (2019). Adopting DevOps in the real world: A theory, a model, and a case study. Journal of Systems and Software, 157, 110384.
[21] Mahajan, A., Gupta, M. K., & Sundar, S. (2018). Cloud-Native Applications in Java: Build microservice-based cloud-native applications that dynamically scale. Packt Publishing Ltd.
[22] Naseer, U., Niccolini, L., Pant, U., Frindell, A., Dasineni, R., & Benson, T. A. (2020, July). Zero downtime release: Disruption-free load balancing of a multi-billion user website. In Proceedings of the Annual conference of the ACM Special Interest Group on Data Communication on the applications, technologies, architectures, and protocols for computer communication (pp. 529-541).
[23] Nyati, S. (2018). Transforming telematics in fleet management: Innovations in asset tracking, efficiency, and communication. International Journal of Science and Research (IJSR), 7(10), 1804-1810. Retrieved from https://www.ijsr.net/getabstract.php?paperid=SR24203184230
[24] Ouni, A., Kula, R. G., Kessentini, M., Ishio, T., German, D. M., & Inoue, K. (2017). Search-based software library recommendation using multi-objective optimization. Information and Software Technology, 83, 55-75.
[25] Peta, V. P., KaluvaKuri, V. P. K., & Khambam, S. K. R. (2021). Smart AI Systems for Monitoring Database Pool Connections: Intelligent AI/ML Monitoring and Remediation of Database Pool Connection Anomalies in Enterprise Applications. ML Monitoring and Remediation of Database Pool Connection Anomalies in Enterprise Applications (January 01, 2021).
[26] Pirozzi, E. (2018). PostgreSQL 10 High Performance: Expert techniques for query optimization, high availability, and efficient database maintenance. Packt Publishing Ltd.
[27] Proksch, S. (2017). Enriched event streams: a general platform for empirical studies on in-IDE activities of software developers (Doctoral dissertation, Technische Universität Darmstadt).
[28] Raju, R. K. (2017). Dynamic memory inference network for natural language inference. International Journal of Science and Research (IJSR), 6(2). https://www.ijsr.net/archive/v6i2/SR24926091431.pdf
[29] Sardana, J. (2022). The role of notification scheduling in improving patient outcomes. International Journal of Science and Research Archive. Retrieved from https://ijsra.net/content/role-notification-scheduling-improving-patient
[30] Senftle, T. P., Hong, S., Islam, M. M., Kylasa, S. B., Zheng, Y., Shin, Y. K., ... & Van Duin, A. C. (2016). The ReaxFF reactive force-field: development, applications and future directions. npj Computational Materials, 2(1), 1-14.
[31] Shaik, B. (2020). PostgreSQL Configuration: Best Practices for Performance and Security. Apress.
[32] Singh, V. (2021). Generative AI in medical diagnostics: Utilizing generative models to create synthetic medical data for training diagnostic algorithms. International Journal of Computer Engineering and Medical Technologies. https://ijcem.in/wp-content/uploads/GENERATIVE-AI-IN-MEDICAL-DIAGNOSTICS-UTILIZING-GENERATIVE-MODELS-TO-CREATE-SYNTHETIC-MEDICAL-DATA-FOR-TRAINING-DIAGNOSTIC-ALGORITHMS.pdf
[33] Singh, V. (2022). EDGE AI: Deploying deep learning models on microcontrollers for biomedical applications: Implementing efficient AI models on devices like Arduino for real-time health monitoring. International Journal of Computer Engineering & Management. https://ijcem.in/wp-content/uploads/EDGE-AI-DEPLOYING-DEEP-LEARNING-MODELS-ON-MICROCONTROLLERS-FOR-BIOMEDICAL-APPLICATIONS-IMPLEMENTING-EFFICIENT-AI-MODELS-ON-DEVICES-LIKE-ARDUINO-FOR-REAL-TIME-HEALTH.pdf
[34] Smart, J. (2020). Sooner safer happier: antipatterns and patterns for business agility. IT Revolution.
[35] Stephenson, M., Sastry Hari, S. K., Lee, Y., Ebrahimi, E., Johnson, D. R., Nellans, D., ... & Keckler, S. W. (2015, June). Flexible software profiling of gpu architectures. In Proceedings of the 42nd Annual International Symposium on Computer Architecture (pp. 185-197).
[36] Stoicescu, M., Fabre, J. C., & Roy, M. (2017). Architecting resilient computing systems: A component-based approach for adaptive fault tolerance. Journal of Systems Architecture, 73, 6-16.
[37] Sukhadiya, J., Pandya, H., & Singh, V. (2018). Comparison of Image Captioning Methods. INTERNATIONAL JOURNAL OF ENGINEERING DEVELOPMENT AND RESEARCH, 6(4), 43-48. https://rjwave.org/ijedr/papers/IJEDR1804011.pdf
[38] Terber, M. (2018). Real-world deployment and evaluation of synchronous programming in reactive embedded systems (Doctoral dissertation, Dissertation, RWTH Aachen University, 2018).
[39] Ugwueze, V. (2024). Cloud Native Application Development: Best Practices and Challenges. International Journal of Research Publication and Reviews, 5, 2399-2412.
[40] Waseem, M., Ahmad, A., Liang, P., Akbar, M. A., Khan, A. A., Ahmad, I., ... & Mikkonen, T. (2024). Containerization in Multi-Cloud Environment: roles, strategies, challenges, and solutions for effective implementation. arXiv preprint arXiv:2403.12980.
[41] Zhu, Y., Richins, D., Halpern, M., & Reddi, V. J. (2015, December). Microarchitectural implications of event-driven server-side web applications. In Proceedings of the 48th International Symposium on Microarchitecture (pp. 762-774).
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 International Journal of Computational and Experimental Science and Engineering
This work is licensed under a Creative Commons Attribution 4.0 International License.
