Php instance and postegre is based on different servers.
On php side we use pg_connect for connection (once for script)
pg_connect("host=127.0.0.1 port=6432 dbname=".$databaseName);
pg_query for transaction
Postegre have 500 max connections.
In pgbouncer.ini
pool_mode - transaction
max_client_conn = 30000
default_pool_size = 500
But load test show that with pgbouncer response time is higher.
What do we do wrong?