#pgbouncer — Public Fediverse posts

This (interesting) article states that the connection budget is split accross the #pgbouncer processes which might be misleading (depending on how you understand it). The max_db_connections and max_ client_conn settings are multiplied by the number of processes. This leads to a situation where #PostgreSQL GUC max_connections may be divided by the number of pgbouncer processes to calculate the max_db_connections. The other way round, you may overload your PG server !

https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres

This (interesting) article states that the connection budget is split accross the #pgbouncer processes which might be misleading (depending on how you understand it). The max_db_connections and max_ client_conn settings are multiplied by the number of processes. This leads to a situation where #PostgreSQL GUC max_connections may be divided by the number of pgbouncer processes to calculate the max_db_connections. The other way round, you may overload your PG server !

https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres

🎉 Congrats on proving that #PgBouncer can scale like a caffeine-fueled hamster on a wheel! 🚀 Meanwhile, actual humans are still trying to figure out what #ClickHouse is doing managing #Postgres, like a cat herding an army of squirrels. 🐿️ Please, share more magical buzzword spells and impressive #SVG logos! 🙄
https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres #scaling #techhumor #HackerNews #ngated

🎉 Congrats on proving that #PgBouncer can scale like a caffeine-fueled hamster on a wheel! 🚀 Meanwhile, actual humans are still trying to figure out what #ClickHouse is doing managing #Postgres, like a cat herding an army of squirrels. 🐿️ Please, share more magical buzzword spells and impressive #SVG logos! 🙄
https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres #scaling #techhumor #HackerNews #ngated

We scaled PgBouncer to 4x throughput

https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres

Comments: https://news.ycombinator.com/item?id=48872874

#HackerNews #PgBouncer #ClickHouse #Scaling #Throughput #Database #Performance

We scaled PgBouncer to 4x throughput

https://clickhouse.com/blog/pgbouncer-clickhouse-managed-postgres

Comments: https://news.ycombinator.com/item?id=48872874

#HackerNews #PgBouncer #ClickHouse #Scaling #Throughput #Database #Performance

Prepared Statement и Java: как не облажаться на собеседовании

На PreparedStatement обычно заканчивается вводный курс по JDBC / PostgreSQL. Все довольно просто, пока не задумываешься: а работает ли оно как надо в моем крутом инновационном приложении? Дальше интереснее: как PostgreSQL выбирает custom или generic plan? кто именно кэширует statements? как с этим дружат ORM и внешние пулы? По закону подлости все выясняется на собеседовании, в контексте “начальных банальных вопросов по БД”. Разберемся в подробностях и закроем эту тему

https://habr.com/ru/articles/1052404/

#postgresql #jdbc #prepared_statements #pgbouncer #spring_boot #orm

I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073

Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.

The problem is that no matter how hard I try to learn and write C, I fail.

I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.

I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.

You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.

#opensource #curl #pgbackrest #pgbouncer #postgresql #ai

I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073

Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.

The problem is that no matter how hard I try to learn and write C, I fail.

I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.

I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.

You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.

#opensource #curl #pgbackrest #pgbouncer #postgresql #ai

Как построить отказоустойчивый PostgreSQL-кластер и не промахнуться

В исходниках PostgreSQL встречаются ироничные комментарии, а самый веселый, на мой взгляд, находится в строке прямо перед запуском сервера. Судя по логам Git, это комментарий Тома Лейна, который сообщает: "We are ready to rock and roll", а следующей строкой идёт запуск сервера СУБД. Действительно, когда пытаешься запустить кластер PostgreSQL, порой не покидает ощущение "rock and roll", а потом вдруг кластер не стартует или внезапно переключается на другой узел из-за отступов в YAML-конфиге :). В этой статье разберём ключевые элементы отказоустойчивого кластера и типовые места, где чаще всего допускают ошибки.

https://habr.com/ru/companies/postgrespro/articles/1004040/

#postgresql #dba #кластер #датацентр #pgBackRest #wal #PgBouncer #мониторинг #Patroni #Stolon

Когда стойка умирает, а 5xx остаётся нулевым. Разбор скрытой деградации PostgreSQL

09:12 — db-replica-02 connection timeout HTTP 5xx = 0.2% HAProxy зелёный p50 = 38-42ms Replica в другой стойке недоступна Отказоустойчивость потеряна Инцидент не объявлен Читать разбор

https://habr.com/ru/articles/1002056/

#PostgreSQL #отказоустойчивость #деградация #retry #HAProxy #PgBouncer #ToR #инцидент #latency #SRE

CloudNativePG versions 1.28.1 and 1.27.3 released, delivering important bug fixes and stability improvements:
1️⃣ Critical fix for #PgBouncer upgrades
2️⃣ Timeline protection during WAL restore
3️⃣ Timeline reset after major upgrades
https://cloudnative-pg.io/releases/cloudnative-pg-1-28.1-released/ #PostgreSQL #Kubernetes

CloudNativePG versions 1.28.1 and 1.27.3 released, delivering important bug fixes and stability improvements:
1️⃣ Critical fix for #PgBouncer upgrades
2️⃣ Timeline protection during WAL restore
3️⃣ Timeline reset after major upgrades
https://cloudnative-pg.io/releases/cloudnative-pg-1-28.1-released/ #PostgreSQL #Kubernetes

Fuzzing PostgreSQL at the front door 🔍

Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/

#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools

Fuzzing PostgreSQL at the front door 🔍

Adam Wołk Microsoft shows how fuzzing uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, mutate protocol inputs, and harden Postgres networking code against real-world failures. https://p2d2.cz/en/talks/knocking_at_the_door_fuzzing_libpq_and_pgbouncer/

#libpq #Fuzzing #DatabaseSecurity #PostgresDev#OpenSource #DBA #DeveloperTools

Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

#PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

Day 1 spotlight! 🌟

🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

Day 1 spotlight! 🌟

🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

#PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

anybody wanna recommend me a favorite GUI way of remotely managing a #Postgres server (you know, create/delete databases, database users etc) which doesn't involve me vastly increasing the attack surface of said server?

major bonus points if it has any awareness / ability to deal with #PgBouncer.

anybody wanna recommend me a favorite GUI way of remotely managing a #Postgres server (you know, create/delete databases, database users etc) which doesn't involve me vastly increasing the attack surface of said server?

major bonus points if it has any awareness / ability to deal with #PgBouncer.

[Blog] Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose: https://www.sqlpassion.at/archive/2025/09/01/running-postgresql-with-pgbouncer-on-macos-using-docker-compose/ #postgres #PostgreSQL #pgbouncer #Docker

[Blog] Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose: https://www.sqlpassion.at/archive/2025/09/01/running-postgresql-with-pgbouncer-on-macos-using-docker-compose/ #postgres #PostgreSQL #pgbouncer #Docker

📣 @pgdaylowlands is almost here! On Sept 11 we'll kick things off with a warm-up meetup 🎉🍕🍻

I'll be talking about scaling #PgBouncer ⚡ Why its single threaded design can hold you back, and how to fix it with real configuration examples and lessons learned from the field 🔧:postgresql:

If you're a #PostgreSQL enthusiast, come join us for an evening full of community vibes 🚀✨ Big thanks to the organizing team 🙌

#PGDayLowlands #PostgresCommunity #OpenSource #TechMeetup

https://www.meetup.com/postgresql-user-group-nl/events/310728717/

📣 @pgdaylowlands is almost here! On Sept 11 we'll kick things off with a warm-up meetup 🎉🍕🍻

I'll be talking about scaling #PgBouncer ⚡ Why its single threaded design can hold you back, and how to fix it with real configuration examples and lessons learned from the field 🔧:postgresql:

If you're a #PostgreSQL enthusiast, come join us for an evening full of community vibes 🚀✨ Big thanks to the organizing team 🙌

#PGDayLowlands #PostgresCommunity #OpenSource #TechMeetup

https://www.meetup.com/postgresql-user-group-nl/events/310728717/

#PgBouncer is useful, important, and fraught with peril

https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html

#PostgreSQL

#PgBouncer is useful, important, and fraught with peril

https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html

#PostgreSQL

Watch how you can diagnose incidents in seconds using #opensource, #eBPF-powered observability. 👇🐧 🐝

Track all communications between cluster components such as #Patroni, #Postgres, #Pgbouncer, and the #Kubernetes API server: https://github.com/coroot/coroot

#Linux #FOSS #observability #postgresql #DevOps #SRE

Watch how you can diagnose incidents in seconds using #opensource, #eBPF-powered observability. 👇🐧 🐝

Track all communications between cluster components such as #Patroni, #Postgres, #Pgbouncer, and the #Kubernetes API server: https://github.com/coroot/coroot

#Linux #FOSS #observability #postgresql #DevOps #SRE

Работа с базой данных для джунов и вайбкодеров. Соединения

Коннекты обычно не приносят много головной боли на начальных этапах разработки. Вообще работа с ними обычно делается один раз, во время настройки, и дальше тюнится по необходимости. Но эта необходимость возникает часто в виде непонятных ошибок, которые выкидываются в случайных местах, непонятных графиков в графане и суеты админов вашей базы данных. Я постарался собрать ту информацию, которая позволит вам не потеряться в такой ситуации и даже поможет определить суть проблемы.

https://habr.com/ru/articles/908376/

#базы_данных #коннекты #баги #коннект_к_бд #пул_соединений #hikaricp #hikaripool #pgbouncer

Volunteering for Hachyderm is a breath of fresh air to me.

On the technical side, creating and adding Ansible roles for PostgreSQL (including PgBouncer and pgBackRest) is fun. I'm learning a lot, even with more than 10 years of experience.

On the human side, I'm honoured to be part of such an amazing worldwide team sharing the same values.

💜💜💜

#hachyderm #postgresql #pgbouncer #pgbackrest

Volunteering for Hachyderm is a breath of fresh air to me.

On the technical side, creating and adding Ansible roles for PostgreSQL (including PgBouncer and pgBackRest) is fun. I'm learning a lot, even with more than 10 years of experience.

On the human side, I'm honoured to be part of such an amazing worldwide team sharing the same values.

💜💜💜

#hachyderm #postgresql #pgbouncer #pgbackrest

Such a privilege to work with #PostgreSQL & #PgBouncer & Citus contributor Jelte Fennema-Nio from the team at Microsoft… who was on stage today at #PGConfdev giving a super cool talk (where Jelte told us what he really thinks) about “The Postgres Protocol: The Good, The Bad and The Future”
#conference #OpenSource #Postgres #Microsoft #database

Such a privilege to work with #PostgreSQL & #PgBouncer & Citus contributor Jelte Fennema-Nio from the team at Microsoft… who was on stage today at #PGConfdev giving a super cool talk (where Jelte told us what he really thinks) about “The Postgres Protocol: The Good, The Bad and The Future”
#conference #OpenSource #Postgres #Microsoft #database

Enjoyed collaborating with Postgres & PgBouncer engineer Emel Simsek who works in the PG team at Microsoft, on her first-ever blog post, published on the Citus Open Source Blog

... about the new support in PgBouncer 1.20.0 for Session vars

(#PgBouncer is one of the more popular connection poolers for #PostgreSQL)
#database #Citus #OpenSource #Microsoft

Enjoy! https://www.citusdata.com/blog/2024/04/04/pgbouncer-supports-more-session-vars/

Enjoyed collaborating with Postgres & PgBouncer engineer Emel Simsek who works in the PG team at Microsoft, on her first-ever blog post, published on the Citus Open Source Blog

... about the new support in PgBouncer 1.20.0 for Session vars

(#PgBouncer is one of the more popular connection poolers for #PostgreSQL)
#database #Citus #OpenSource #Microsoft

Enjoy! https://www.citusdata.com/blog/2024/04/04/pgbouncer-supports-more-session-vars/

Wait...what? #pgbouncer gets support for prepared statements? Niiiiice.

https://github.com/pgbouncer/pgbouncer/pull/845

#postgresql #postgres

Wait...what? #pgbouncer gets support for prepared statements? Niiiiice.

https://github.com/pgbouncer/pgbouncer/pull/845

#postgresql #postgres

New episode: "Connection poolers"

Nikolay and Michael discuss #Postgres connection poolers — when and why we need them, the king that is #PgBouncer, and the many new pretenders to the throne.

🎙️ https://postgres.fm/episodes/connection-poolers

📺 https://youtu.be/615iO3_SAXw

#postgresql

Is there a convinient way to configure #pgbouncer without adding every user to userlist.txt? #postgresql

Although if anyone is running #dendrite, I would be interested to hear if setting up #PGBouncer for connection pooling is useful. All my reading has suggested “maybe”

#matrix #postgres

Team #pgBouncer is ready to bounce the #PostgreSQL devroom at #FOSDEM - however the doors are still locked.

Very efficient bouncing.