| website | https://p2d2.cz |
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! 🇨🇿💙
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
“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.
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/
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/
“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
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
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