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_ · Accepted solution]

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.

[Marat Popov]

Hi @Piyush Annadate _ACE Pune_ 

Thanks for your reply! I will read these articles and try to apply to my case.

[Piyush Annadate _ACE Pune_]

Welcome @Marat Popov