#p2d2 — Public Fediverse posts

At @p2d2 Bruce Momjian delivered an all-new talk titled "What's missing in Postgres?": https://momjian.us/main/presentations/pending.html#missing

Bruce: "One thing I learned in writing the talk is that the majority of our missing features are performance-related, rather than functionality-related!"
#P2D2 #PostgreSQL

That’s a wrap at #P2D2! 🎉 Huge thanks to our amazing speakers, organizers, and attendees for making it unforgettable.

PostgreSQL, people, and Prague—what a combo. We can’t wait to do it again next year. See you soon — brzy na viděnou! 🇨🇿💙

“It works on my database” 😅

Radim Marek shows why that’s not enough. Learn how RegreSQL brings PostgreSQL-style regression testing to application SQL—catching correctness bugs and performance regressions before prod. https://p2d2.cz/en/talks/it_works_on_my_database_regression_testing_of_sql_queries/

#PostgreSQL #P2D2 #PPDD #SQL #Testing #RegressionTesting #DatabaseDev

Observability beyond the database. ☁️

Peter Zaitsev explores cloud-native Postgres monitoring—from client apps to VMs, storage, and networks. Learn how eBPF, service maps, and Kubernetes operators help track Postgres in dynamic cloud environments. https://p2d2.cz/en/talks/cloud_native_postgres_observability_from_client_apps_to_underlying_cloud_resources/

#PostgreSQL #P2D2 #Observability #Cloud

How much performance is left on the table with default settings? 🤔

Luigi Nardi presents a benchmark study on PostgreSQL server parameter tuning, comparing OLTP and OLAP workloads and showing how hardware and environment change the results. https://p2d2.cz/en/talks/a_benchmark_study_on_the_impact_of_postgresql_server_parameter_tuning/

#PostgreSQL #P2D2 #Performance

“Heeey, I’m using that!” 😅

Ants Aasma digs into OLTP lock contention in PostgreSQL—why it happens, how isolation levels, latency, and concurrency control affect it, and how to fix it without breaking correctness.

#PostgreSQL #P2D2 #OLTP #Performance

What really changes at 100TB+? 🤯

Teresa Lopes shares hard-won lessons from running massive PostgreSQL databases at Adyen—covering backups, HA, vacuum, and performance when “best practices” stop working. https://lnkd.in/d_QD95ZG

#PostgreSQL #P2D2 #PGScale #Databases

Incredible Lightning Talks at P2D2 hosted by Pavlo Golub! ⚡

Our taleted speakers showcased projects like pg_scorecard and pg_dance in under 5 mins. Huge thanks to Mayuresh B., Michal Bartak, Sergey Chekhuta, Alijaz Mur Erzen, Josef Machytka, Henrietta Dombrovskaya, Ants Aasma, Jonathan Battiato, Ellyne P., Mohsin Ejaz, Anton Borisov, Luigi Nardi 🙌

Slides: https://lnkd.in/dfRNUYeQ

#P2D2 #PostgreSQL #LightningTalks

PostgreSQL 18 brings big upgrades to constraints! 🔒

Gülçin Yıldırım Jelínek breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. https://lnkd.in/d_xZ6HD2

#PostgreSQL #P2D2 #PG18 #DataIntegrity

PostgreSQL 18 brings big upgrades to constraints! 🔒

Gülçin Yıldırım Jelínek breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. https://lnkd.in/d_xZ6HD2

#PostgreSQL #P2D2 #PG18 #DataIntegrity

PostgreSQL 18 brings big upgrades to constraints! 🔒

Gülçin Yıldırım Jelínek breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. https://lnkd.in/d_xZ6HD2

#PostgreSQL #P2D2 #PG18 #DataIntegrity

PostgreSQL 18 brings big upgrades to constraints! 🔒

Gülçin Yıldırım Jelínek breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. https://lnkd.in/d_xZ6HD2

#PostgreSQL #P2D2 #PG18 #DataIntegrity

PostgreSQL 18 brings big upgrades to constraints! 🔒

Gülçin Yıldırım Jelínek breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. https://lnkd.in/d_xZ6HD2

#PostgreSQL #P2D2 #PG18 #DataIntegrity

Explore TimescaleDB for IoT!

Michal Bartak shows how to collect & visualize data using continuous aggregates, compression, and retention strategies. Learn how dataset types impact Grafana dashboards and maintain your time-series data efficiently.

#PostgreSQL #TimescaleDB #IoT #P2D2

Do ORMs make you 😃 or 😡? Petr Šmejkal Outreach explores building Go services on PostgreSQL, shares his take on sqlc—what works, what doesn’t, and how to fix pitfalls. Learn practical ways to make your SQL + Go workflows smooth and reliable!

#PostgreSQL #ORM #Go #P2D2

Think your PostgreSQL tuning guide works for all setups? Think again! 🚨 Mohsin Ejaz shows why generic advice can fail and how infrastructure—storage, IOPS, JIT, cloud vs on-prem—shapes the optimal configuration. Tune PostgreSQL the right way!

#PostgreSQL #Performance #P2D2

Help us collect attendee stats for P2D2 and support our sponsors 🙌

Fill in our short form and you’ll be entered into a draw to win one of 3 copies of Jimmy Angelakos's book "PostgreSQL Mistakes and How to Avoid Them” 📘🎉

Survey link: https://p2d2.cz/stats

#P2D2 #PostgreSQL #Community #Giveaway

Don’t forget the hallway track ☕️🤝 That’s where great coffee meets sponsor booths, spontaneous Postgres chats, and reconnecting with old friends—or making new ones. Some of the best insights happen between the talks!

#P2D2 #PostgreSQL #HallwayTrack #PostgresCommunity

Special guest spotted at P2D2 👀🐘

Our Slonik mascot made a surprise appearance, spreading good vibes, Postgres pride, and a few smiles around the venue. Turns out even elephants love a great PostgreSQL conference! 💚

#P2D2 #PostgreSQL #Slonik #PostgresCommunity

Zero downtime, zero drama.

Anton Borisov shares how Fresha upgraded dozens of PostgreSQL clusters from 12 → 17 using logical replication, PgBouncer choreography, and blue-green switches—without breaking traffic or CDC. https://p2d2.cz/en/talks/switching_me_softly_zero_downtime_major_postrgresql_upgrades_at_fresha/

#PostgreSQL #P2D2 #Upgrades #DevOps

PostgreSQL evolves fast—yet some big features are still missing.

Bruce Momjian explores why sharding, TDE, global indexes, and multi-master replication aren’t in Postgres (yet), and what that means for the future. https://p2d2.cz/en/talks/whats_missing_in_postgres/

#PostgreSQL #P2D2

SQL injection is just the beginning.

Kranthi Kiran Burada & Narendra Tawar uncover advanced PostgreSQL threats—from FDW abuse and side channels to logical replication misuse and RLS pitfalls. https://lnkd.in/duc7FPyD

#PostgreSQL #Security #P2D2

How do B-tree indexes really work—and how should you tune them today (and tomorrow)?

Jakub Kužela dives into index access paths, skip scans, automated indexing, and the future of self-tuning databases. https://lnkd.in/dczDjfA8

#PostgreSQL #Indexes #Performance #P2D2

Do you really need Kafka for every queue? 🤔

Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ

#PostgreSQL #PgQ #P2D2 #EventDriven #Databases

Do you really need Kafka for every queue? 🤔

Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ

#PostgreSQL #PgQ #P2D2 #EventDriven #Databases

Do you really need Kafka for every queue? 🤔

Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ

#PostgreSQL #PgQ #P2D2 #EventDriven #Databases

Do you really need Kafka for every queue? 🤔

Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ

#PostgreSQL #PgQ #P2D2 #EventDriven #Databases

Do you really need Kafka for every queue? 🤔

Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ

#PostgreSQL #PgQ #P2D2 #EventDriven #Databases

How do you really clean up PostgreSQL at scale? 🧹🐘

Çağrı Biroğlu dives into autovacuum internals, safe deletion patterns, and avoiding vacuum storms in high-concurrency systems. https://lnkd.in/dh6SKhJ9

#PostgreSQL #P2D2 #Autovacuum #Internals #Performance

Kicking off P2D2 with a packed morning! 🚀 Tomas Vondra opened the day with the introduction as we return to this venue for the 11th year. 320 attendees and lots of Postgres energy in the room—are you excited for the day ahead? 🐘✨

#P2D2 #PostgreSQL #PGDay #PostgresCommunity #Prague #TechConference

Hands-on monitoring at P2D2! 🐘 Pavlo Golub led pgwatch: From Zero to Hero!, guiding attendees through setup, connecting PostgreSQL instances, exploring Grafana dashboards, and managing multiple clusters. Practical tips for production-ready Postgres monitoring.

#PostgreSQL #P2D2 #pgwatch #Monitoring #Grafana #DBA #PostgresOps #OpenSource

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

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

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 and cloud-native at #P2D2 🚀 Jonathan Battiato & Danish K. walked attendees through running PostgreSQL on Kubernetes with CloudNativePG—from first cluster deploy to backups, failover, and recovery. A practical deep dive into declarative Postgres ops in K8s. 🐘☸️

#PostgreSQL #CloudNativePG #Kubernetes #DevOps #DBA #CloudNative #PostgresOnK8s #OpenSource #CNCF

📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

#PostgreSQL #QueryOptimization #DatabasePerformance

📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

#PostgreSQL #QueryOptimization #DatabasePerformance

📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

#PostgreSQL #QueryOptimization #DatabasePerformance

📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

#PostgreSQL #QueryOptimization #DatabasePerformance

📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

#PostgreSQL #QueryOptimization #DatabasePerformance

🚀 Day 1 at #P2D2 — workshops happening this morning: PostgreSQL Query Optimization (Hettie Dombrovskaya), Running PostgreSQL in Kubernetes with CloudNativePG (Jonathan & Danish), and Introduction to Postgres Hacking (Tomas Vondra, Nazir Bilal Yavuz). ☕🐘

#PostgreSQL #P2D2 #Workshops #Training #Kubernetes #CloudNativePG

Our Prague PostgreSQL Meetup was a hit! 🎉 Teresa Lopes, Josef Machytka & Luigi Nardi shared insights on Postgres at scale, high-speed pipelines & AI in databases. Great discussions and networking ahead of P2D2 2026! #PostgreSQL #PGDay #P2D2 #TechCommunity

Check out the SQL talks at #P2D2 🧠 From PgQ queues (Alexander Kukushkin, 9:20) and what Postgres is still missing (Bruce Momjian, 10:15) to ORMs vs SQL (Petr Šmejkal, 11:10), constraints in PG18 (Gulcin Yildirim Jelinek, 14:15) and SQL regression testing (Radim Marek, 16:30).

#PostgreSQL #PPDD #SQL

PostgreSQL performance deep dives at #P2D2 🚀 From 100TB+ databases (Teresa Lopes) to index tuning (Jakub Kuzela), fixing lock contention (Ants Aasma), smarter tuning (Mohsin Ejaz, Luigi Nardi) and query monitoring (Grant Fritchey). Don’t miss these talks!

#PostgreSQL #PPDD #Performance

Save the date!

Prague PostgreSQL Developer Day returns 27–28 January 2026. Join us for two days of talks, tech, and community. 🇨🇿🐘

Watch this space for more details! https://p2d2.cz/

#Prague #P2D2 #PostgreSQL #techtalks