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! 🇨🇿💙
Prague PostgreSQL Dev Day
A community conference in Prague, organized by CSPUG.
website
Prague PostgreSQL Dev Day boosted:
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
Prague PostgreSQL Dev Day boosted:
“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.
Prague PostgreSQL Dev Day boosted:
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/
Prague PostgreSQL Dev Day boosted:
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/
Prague PostgreSQL Dev Day boosted:
“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
Prague PostgreSQL Dev Day boosted:
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
Prague PostgreSQL Dev Day boosted:
Discover PostgreSQL performance monitoring from the ground up with Grant Fritchey! Learn to identify slow queries, analyze execution plans, and use built-in tools to understand why your DB lags. Perfect for beginners aiming to master query performance.
Discover PostgreSQL performance monitoring from the ground up with Grant Fritchey! Learn to identify slow queries, analyze execution plans, and use built-in tools to understand why your DB lags. Perfect for beginners aiming to master query performance.
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
“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/
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/
“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.
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
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
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
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.
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!
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!
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst