Academic Journal
PostgreSQL Tuning for Cloud-Native Java: Connection Pooling vs. Reactive Drivers.
| 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 |
| FullText | Text: Availability: 0 |
|---|---|
| Header | DbId: edb DbLabel: Complementary Index An: 191566976 RelevancyScore: 1007 AccessLevel: 6 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 1007.33386230469 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: PostgreSQL Tuning for Cloud-Native Java: Connection Pooling vs. Reactive Drivers. – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Gundla%2C+Sandeep+Reddy%22">Gundla, Sandeep Reddy</searchLink> – Name: TitleSource Label: Source Group: Src Data: International Journal of Computational & Experimental Science & Engineering Experimental Science & Engineering (IJCESEN); 2025, Vol. 11 Issue 3, p5405-5421, 17p – Name: Subject Label: Subject Terms Group: Su Data: <searchLink fieldCode="DE" term="%22SQL%22">SQL</searchLink><br /><searchLink fieldCode="DE" term="%22Cloud+computing%22">Cloud computing</searchLink><br /><searchLink fieldCode="DE" term="%22Java+programming+language%22">Java programming language</searchLink><br /><searchLink fieldCode="DE" term="%22Computer+software+development%22">Computer software development</searchLink><br /><searchLink fieldCode="DE" term="%22Relational+databases%22">Relational databases</searchLink> – Name: Abstract Label: Abstract Group: Ab Data: 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] – Name: Abstract Label: Group: Ab Data: <i>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.</i> (Copyright applies to all Abstracts.) |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edb&AN=191566976 |
| RecordInfo | BibRecord: BibEntity: Identifiers: – Type: doi Value: 10.22399/ijcesen.3479 Languages: – Code: eng Text: English PhysicalDescription: Pagination: PageCount: 17 StartPage: 5405 Subjects: – SubjectFull: SQL Type: general – SubjectFull: Cloud computing Type: general – SubjectFull: Java programming language Type: general – SubjectFull: Computer software development Type: general – SubjectFull: Relational databases Type: general Titles: – TitleFull: PostgreSQL Tuning for Cloud-Native Java: Connection Pooling vs. Reactive Drivers. Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Gundla, Sandeep Reddy IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 07 Text: 2025 Type: published Y: 2025 Identifiers: – Type: issn-print Value: 21499144 Numbering: – Type: volume Value: 11 – Type: issue Value: 3 Titles: – TitleFull: International Journal of Computational & Experimental Science & Engineering Experimental Science & Engineering (IJCESEN) Type: main |
| ResultId | 1 |