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