PgBouncer Tutorial

0:00 - Introduction
0:53 - Fundamental concepts of connection pooling
3:16 - Building a PgBouncer Setup
5:15 - Installing and Configure PgBouncer
5:53 - Creating a basic configuration file for PgBouncer
9:08 - Connecting to PgBouncer
10:21 - Advanced Settings for Performance
13:17 - Pool Modes
15:08 - A simple benchmark

🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.

[kerodfresenbetgebremedhin]

this tier of programming is untouched in the youtube space, great job

[panagiotisdeligiannis]

A nice gain? Bro, this is 1200% performance increase!!! I feel like a caveman working without a pooler for so long.

Still, I have raised my own questions regarding authentication between the application and pgBouncer and between pgBouncer and Postgres, but this seems really helpful!

[supa]

Amazing video - you are a great teacher!

[decipheringthematrix]

Great topic, I've used pgbouncer in the past, quite a dramatic difference huh.

[lenauser]

Thank you very much! Very interesting video!

[HandleAdded]

you r the BEST ❤️ i like ur Solr tutorials 👍

[ramsiddu]

Thanks again for sharing such a great concept.

[matt-sokola]

I love your tutorial it clearly explained the benefits of using pgbouncer. Have you ever used it in kubernetes? Should pgbouncer be run on the same pod as postgres or can be on different ones?

[PauloVFSC]

Nice topic! By the way, where did you get the information of 350 concurrent connections standalone?

[rohitgarg]

I have a question here max_client_connection value in pgbouncer.ini file is basically queue size or client connection between application and pgbouncer ?

[juancarlospastillo]

Buenas tardes, me podrían ayudar estoy conectando pgbouncer con postgres con método de encriptacion scram-sha-256 y archivo pg_auth. Pero me presenta el mensaje .... *Psql: error: FATAL: server login FAILED: wrong password type*... Que podría ser?

[Muchlis--jmms]

with pgbouncer, is it still good to use database pool in client side?

[jirehla-ab]

can I run pgbouncer without specifying the default database postgres?
like leaving dbname empty?
what if I set dbname = * wildcard?

[adnanmujagic]

Did I misunderstand something? I googled that the Postgresql can manage more thousands of transactions per second, but in the video, he mentioned up to 350 transactions per second?

[Stanoweb]

Thanks for sharing.. a quick question. .currently I have 1 HAProxy + 3 Postgres Server (using Patroni).. does't it make sense to put PgBouncer in front of the HAProxy ?
Clients -> PgBouncer -> HaProxy --> PG Cluster.
Or
Clients -> HaProxy -> PgBouncer ( * 3) -> PG Cluster?

[pavankumar-jytf]

how to install pgbouncer in windows server