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.
“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
📍 See you tomorrow at Prague PostgreSQL Developer Day!
⚠️ Please note: Tomorrow (27 Jan) is workshops only, conference talks will take place on Wednesday (28 Jan).
Venue: ČVUT FIT, Thákurova 9, Praha 6
🚇 Metro Dejvická, ~5 min walk
📝 Registration: https://lnkd.in/eTmWGmvb
Get ready for a great day of Postgres! 🚀
Go deep into PostgreSQL internals 🔍 Learn about advanced security threats beyond SQL injection (Kranthi Kiran Burada & Narendra Tawar, 10:15), autovacuum and XID wraparound fixes for large tables (Robert Treat, 11:10), and safe data cleanup strategies (Cagri Biroglu, 14:15).
PostgreSQL at scale 🔐☸️ Zero-downtime upgrades (Anton Borisov, 10:15), IoT data pipelines with TimescaleDB (Michal Bartak, 11:10), cloud-native Postgres observability & containers (Peter Zaitsev, 15:35), and fuzzing libpq & PgBouncer for security (Adam Wolk, 16:30).
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 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!
⚡ Call for Lightning Talks – Prague Postgres Developers Day 2026!
Got a cool idea, extension, tip, or Postgres story? Share it in 5 minutes. No demos, just sharp slides. Apply now and take the stage on Jan 28! 🚀 https://lnkd.in/dyxtkAx4
Want to hack PostgreSQL itself? 🛠️
T9:347, Day 1 spotlight: Tomas Vondra & Nazir Bilal Yavuz guide you through Postgres internals, C code, source layout, tests, and contribution workflows. Two hands-on sessions for future contributors. ▶️ Don’t miss it!
Day 1 in T9:302! ☸️
🕘 9:00 – Jonathan & Danish: Hands-on workshop deploying PostgreSQL on Kubernetes with CloudNativePG. Learn cluster management, backups, self-healing, and more.
🕘 13:30 – Pavlo Golub: Master pgwatch monitoring, Grafana dashboards, and PostgreSQL metrics. ▶️ Don’t miss it!
Prague PostgreSQL Dev Day