#ppdd — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #ppdd, aggregated by home.social.
-
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/eTmWGmvbGet 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!
-
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
-
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
-
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
-
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14 -
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14 -
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14 -
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14 -
#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times. Practical examples and real performance gains.
▶️ Watch now! https://www.youtube.com/watch?v=cXIRGGD_TZ8&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14 -
#throwback Autovacuum tuning meets cloud cost reality 💸☁️ Mayuresh Bagayatkar shows how to balance PostgreSQL performance, maintenance, and FinOps across AWS, GCP, and Azure. Learn real-world tricks to tune autovacuum without overspending.
▶️ Watch now! https://www.youtube.com/watch?v=-u-Np5ZE8r0&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=14
-
#throwback Think EXPLAIN tells the whole story? 👀 Ants Aasma reveals the hidden performance gremlins PostgreSQL plans don’t show—TOAST lookups, visibility checks, hint bits, and more. Learn how to spot what’s slowing you down.
▶️ Watch now! https://www.youtube.com/watch?v=y07-VLh7Sxc&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=12
-
#throwback Incremental backups are coming to PostgreSQL 🚀 Robert Haas explains the new incremental backup feature in PostgreSQL 17—how changed data is tracked, how backups and restores work, and when to use them. A must-watch for DBAs.
▶️ Watch now!
https://www.youtube.com/watch?v=q9S9ITgJAKc&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=11 -
#throwback Want to push PostgreSQL performance further? ⚡ Somdyuti Paul dives into advanced tuning with real-world demos—plan caching, GEQO, partitions, parallel queries, and index scan pitfalls. Practical insights you can apply immediately.
▶️ Watch now! https://www.youtube.com/watch?v=IPlHrUHKMY4&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=10
#PostgreSQL #PGDay #PPDD #PerformanceTuning #DatabaseOptimization
-
#throwback Want to push PostgreSQL performance further? ⚡ Somdyuti Paul dives into advanced tuning with real-world demos—plan caching, GEQO, partitions, parallel queries, and index scan pitfalls. Practical insights you can apply immediately.
▶️ Watch now! https://www.youtube.com/watch?v=IPlHrUHKMY4&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=10
#PostgreSQL #PGDay #PPDD #PerformanceTuning #DatabaseOptimization
-
#throwback Want to push PostgreSQL performance further? ⚡ Somdyuti Paul dives into advanced tuning with real-world demos—plan caching, GEQO, partitions, parallel queries, and index scan pitfalls. Practical insights you can apply immediately.
▶️ Watch now! https://www.youtube.com/watch?v=IPlHrUHKMY4&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=10
#PostgreSQL #PGDay #PPDD #PerformanceTuning #DatabaseOptimization
-
#throwback Want to push PostgreSQL performance further? ⚡ Somdyuti Paul dives into advanced tuning with real-world demos—plan caching, GEQO, partitions, parallel queries, and index scan pitfalls. Practical insights you can apply immediately.
▶️ Watch now! https://www.youtube.com/watch?v=IPlHrUHKMY4&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=10
#PostgreSQL #PGDay #PPDD #PerformanceTuning #DatabaseOptimization
-
#throwback Want to push PostgreSQL performance further? ⚡ Somdyuti Paul dives into advanced tuning with real-world demos—plan caching, GEQO, partitions, parallel queries, and index scan pitfalls. Practical insights you can apply immediately.
▶️ Watch now! https://www.youtube.com/watch?v=IPlHrUHKMY4&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=10
#PostgreSQL #PGDay #PPDD #PerformanceTuning #DatabaseOptimization
-
#throwback AI meets PostgreSQL 🤖 Ayse Bilge Ince shows how pgvector, aidb, and LLMs are turning Postgres into an intelligent data platform. Learn practical ways to use AI in your architecture and explore what’s next for AI-powered Postgres.
▶️ Watch now! https://lnkd.in/dvHX7T4t
-
Is synchronous replication really slow—or a silver bullet for zero data loss? 🤔 Alexander Kukushkin breaks down myths vs. reality, sharing real-world tests and trade-offs of PostgreSQL synchronous replication. Learn when and how to use it right.
▶️ Watch now! https://www.youtube.com/watch?v=axkIoqxQzNQ&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=8
-
#throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.▶️ Watch now! https://www.youtube.com/watch?v=aB5dNcpBI44&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=7
-
#throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.▶️ Watch now! https://www.youtube.com/watch?v=aB5dNcpBI44&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=7
-
#throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.▶️ Watch now! https://www.youtube.com/watch?v=aB5dNcpBI44&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=7
-
#throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.▶️ Watch now! https://www.youtube.com/watch?v=aB5dNcpBI44&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=7
-
#throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.▶️ Watch now! https://www.youtube.com/watch?v=aB5dNcpBI44&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=7
-
#throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.
▶️ Watch now! https://www.youtube.com/watch?v=qTtt6AtuQ9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=6
#PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance
-
#throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.
▶️ Watch now! https://www.youtube.com/watch?v=qTtt6AtuQ9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=6
#PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance
-
#throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.
▶️ Watch now! https://www.youtube.com/watch?v=qTtt6AtuQ9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=6
#PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance
-
#throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.
▶️ Watch now! https://www.youtube.com/watch?v=qTtt6AtuQ9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=6
#PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance
-
#throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.
▶️ Watch now! https://www.youtube.com/watch?v=qTtt6AtuQ9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=6
#PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance
-
#throwback PostgreSQL on Kubernetes made practical ☸️ Vojtěch Mareš introduces CloudNativePG and shows how to run highly available Postgres on k8s—almost like a managed service. Real production lessons from SaaS and enterprise setups.
▶️ Watch now! https://www.youtube.com/watch?v=ODWBtOXbm6k&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=5
#PostgreSQL #PGDay #PPDD #Kubernetes #CloudNativePG -
#throwback From data swamp to data lakehouse 🏗️ Josef Machytka shares real-world lessons on building a lakehouse with PostgreSQL, BigQuery, and GCS—covering formats, scaling, governance, and data quality. Keep your data clean and useful. ▶️ Watch now! https://www.youtube.com/watch?v=AUdEjYnXGbI&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=4
-
#throwback Struggling with downtime during schema changes? 🔒 Gulcin Yildirim Jelinek breaks down table-level locks, lock queues, and zero-downtime DDL strategies in PostgreSQL. Learn how to avoid deadlocks and minimize impact.
▶️ Watch the talk now! https://www.youtube.com/watch?v=kKNZsGezZ4g&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=3
-
#throwback What really happens inside a PostgreSQL cluster after failover? 🔄 David Pech dives deep into failover, switchover, split-brain scenarios, and recovery strategies—manually breaking down how tools like Patroni work.
▶️ Watch the video now! https://lnkd.in/dQiiBvXX
-
#throwback What really happens inside a PostgreSQL cluster after failover? 🔄 David Pech dives deep into failover, switchover, split-brain scenarios, and recovery strategies—manually breaking down how tools like Patroni work.
▶️ Watch the video now! https://lnkd.in/dQiiBvXX
-
#throwback What really happens inside a PostgreSQL cluster after failover? 🔄 David Pech dives deep into failover, switchover, split-brain scenarios, and recovery strategies—manually breaking down how tools like Patroni work.
▶️ Watch the video now! https://lnkd.in/dQiiBvXX
-
#throwback What really happens inside a PostgreSQL cluster after failover? 🔄 David Pech dives deep into failover, switchover, split-brain scenarios, and recovery strategies—manually breaking down how tools like Patroni work.
▶️ Watch the video now! https://lnkd.in/dQiiBvXX
-
#throwback What really happens inside a PostgreSQL cluster after failover? 🔄 David Pech dives deep into failover, switchover, split-brain scenarios, and recovery strategies—manually breaking down how tools like Patroni work.
▶️ Watch the video now! https://lnkd.in/dQiiBvXX
-
#throwback How does multi-master PostgreSQL really perform under pressure? 🔁 Alfredo Rodriguez shares a real-world case study using pgEdge/spock, stress-testing millions of transactions, conflicts, latency, and failover scenarios.
▶️ Watch the talk now! https://www.youtube.com/watch?v=79ueF49PI9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced