PgBouncer Tutorial

[@kerodfresenbetgebremedhin1881]

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

[@panagiotisdeligiannis9610]

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!

[@supa1009]

Amazing video - you are a great teacher!

[@LearnValkey]

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?

[@decipheringthematrix56]

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

[@maxonaga3962]

Some real information, congrats.

[@HandleAdded1]

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

[@ramsiddu007]

Thanks again for sharing such a great concept.

[@albertospadoni1581]

Great video, a big thank you

[@jirehla-ab1671]

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

[@Coffops]

Thank you for your time!

[@PauloVFSC]

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

[@stevenchang4784]

good job~~ Thank you!!😀

[@Muchlis--jm3ms]

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

[@supern4ut3]

Awesome content!

[@tikola_nesla]

Thank you!

[@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?

[@phungnet001]

Clients -> HaProxy -> PgBouncer ( * 3) -> PG Cluster

[@adnanmujagic171]

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?

[@JeisonChollet]

I believe the difference is between transactions and connections. Maybe it's thousands of transactions with few connections.

[@pavankumar-jy3tf]

how to install pgbouncer in windows server

[@SadanandGopal17feb]

Feels like u r reading the book

[@pghelp]

Its a transcript from PostgreSQL replication, second edition book , topic: "Working with PgBouncer"