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!
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?
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?
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?
this tier of programming is untouched in the youtube space, great job
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!
Amazing video - you are a great teacher!
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?
Great topic, I've used pgbouncer in the past, quite a dramatic difference huh.
Nice topic! By the way, where did you get the information of 350 concurrent connections standalone?
Great video, a big thank you
you r the BEST ❤️ i like ur Solr tutorials 👍
Some real information, congrats.
Thanks again for sharing such a great concept.
can I run pgbouncer without specifying the default database postgres?
like leaving dbname empty?
what if I set dbname = * wildcard?
Thank you for your time!
Awesome content!
with pgbouncer , is it still good to use database pool in client side?
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?
Clients -> HaProxy -> PgBouncer ( * 3) -> PG Cluster
Thank you!
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?
I believe the difference is between transactions and connections. Maybe it's thousands of transactions with few connections.
Feels like u r reading the book
Its a transcript from PostgreSQL replication, second edition book , topic: "Working with PgBouncer"
how to install pgbouncer in windows server