Here in this recipe we are going to implement PgBouncer and benchmark the results for database connections made to the database via PgBouncer against normal database connections.
Before we configure and implement connection pooling, the PgBouncer utility must be installed prior to performing the steps mentioned in this recipe. Installing PgBouncer is covered in the previous recipe.
pgbouncer.iniconfiguration file, as shown in the following snippet. The first two entries are for the databases that will be passed through PgBouncer. Next we configure the
*, which means that it is going to listen ...