Auditing PostgreSQL & Pgpool instances
TELECOMMUNICATIONS
March 2021 – April 2021 (1 month)
Bordeaux, France
Our objective for this mission: to find the most optimal solution for managing incoming and outgoing PostgreSQL connections.
DOTIC requested an audit of its PostgreSQL and PGPool configuration to resolve issues causing ETL jobs to stall as well as daily production workload.
Their initial configuration of PostgreSQL and PGPool only allowed 500 simultaneous connections.
All connections above 500 were sent to a queue, blocking new incoming user connections.
This limit of 500 connections was not defined in a specific place but was found to be the consequence of several parameters of
different configuration in PostgreSQL, PGPool and Linux host kernel.
After an in-depth audit of PostgreSQL, PGPool and Linux, we identified several parameters involved and DOTIC can thus increase the number of connections according to the real resources of their machine.