Does Pgpool-II improve DB and Jira perfomance?

Marat Popov

I'm searching for the ways to enchance the Jira performance. Sometimes my system has slowdowns and it is caused by Connection pools and pools' configuration.

I can increase the pools number to 40 as it is recommended, but I'm afraid that will only resolve the problem partially.

Today I learned about Pgpool-II that it has many strengths in implementing the connection between Jira and DB. I'm going to upgrade Jira to version 10.3.5 and using Postgres DB.

Have you ever used Pgpool-II and would you recommend it in my case?

Piyush Annadate _ACE Pune_

Hello @Marat Popov ,
I did a review once, never used though. Few details I can recall as below:

-Connection Pooling: Reduces the overhead of establishing new connections by reusing existing ones, leading to improved performance and reduced resource consumption.
https://confluence.atlassian.com/adminjiraserver101/connecting-jira-applications-to-pgpool-ii-1455427783.html

-Load Balancing: Distributes client requests across multiple PostgreSQL servers, ensuring optimal resource utilization.https://stackoverflow.com/questions/75903254/whats-the-best-connections-settings-for-pgpool-4-4-0-with-postgresql-12-5

-High Availability: Supports configurations with automatic failover and online recovery, minimizing downtime.
https://www.pgpool.net/docs/latest/en/html/runtime-config-connection-pooling.html


There were some cases wherein users reported issues with Jira attempting operations against standby databases during startup when using Pgpool-II's load balancing; check if that's valid in your case. Do all the testing in UAT with stress and load testing for sure.