PostgreSQL Tuning for Cloud-Native Java: Connection Pooling vs. Reactive Drivers.
Saved in:
| Title: | PostgreSQL Tuning for Cloud-Native Java: Connection Pooling vs. Reactive Drivers. |
|---|---|
| Authors: | Gundla, Sandeep Reddy |
| Source: | International Journal of Computational & Experimental Science & Engineering Experimental Science & Engineering (IJCESEN); 2025, Vol. 11 Issue 3, p5405-5421, 17p |
| Subject Terms: | SQL, CLOUD computing, JAVA programming language, COMPUTER software development, RELATIONAL databases |
| Abstract: | 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, eventdriven, 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. [ABSTRACT FROM AUTHOR] |
| Copyright of International Journal of Computational & Experimental Science & Engineering Experimental Science & Engineering (IJCESEN) is the property of Journal of Computational Experimental Science, Engineering Experimental Science & Engineering and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) | |
| Database: | Complementary Index |
Nájsť tento článok vo Web of Science Be the first to leave a comment!