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 #PGDay #PPDD
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).
#PostgreSQL #PGDay #PPDD
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
⚡️ 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! 🚀
#PostgreSQL #PPDD #LightningTalks #PGCommunity
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. ▶️ Don’t miss it!
#PostgreSQL #PGDay #PPDD #PostgresHacking #OpenSource
Day 1 in T9:302! ☸️
🕘 9:00 – Jonathan & Danish: Deploy PostgreSQL on Kubernetes with #CloudNativePG
🕘 13:30 – Pavlo Golub: Master PGWatch
▶️ Don’t miss it!
#PostgreSQL #PGDay #PPDD #Kubernetes #pgwatch
Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Learn how to write efficient queries
🕜 13:30 – Josef Machytka: Learn everything about #PGBouncer
▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #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.
▶️ Watch now! www.youtube.com/watch?v=cXIR...
#PostgreSQL #PGDay #PPDD #SQL #WindowFunctions
#throwback Autovacuum tuning meets cloud cost reality 💸☁️ Mayuresh Bagayatkar shows how to balance PostgreSQL performance, maintenance, and FinOps, real-world tricks to tune autovacuum without overspending.
▶️ Watch now! www.youtube.com/watch?v=-u-N...
#PostgreSQL #PGDay #PPDD #Autovacuum #FinOps
#throwback Think EXPLAIN tells the whole story? 👀 Ants Aasma reveals the hidden performance gremlins PostgreSQL plans don’t show, learn how to spot what’s slowing you down.
▶️ Watch now! www.youtube.com/watch?v=y07-...
#PostgreSQL #PGDay #PPDD #QueryPerformance #ExplainPlan
#throwback Incremental backups are coming to PostgreSQL 🚀 Robert Haas explains the new incremental backup feature in PostgreSQL 17. Watch now:
www.youtube.com/watch?v=q9S9...
#PostgreSQL #PGDay #PPDD #Postgres17 #Backup
#throwback Want to push PostgreSQL performance further? ⚡ Somdyuti Paul dives into advanced tuning with real-world demos—plan caching, GEQO and more. ▶️ Watch now! www.youtube.com/watch?v=IPlH...
#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 and explore what’s next for AI-powered Postgres.
▶️ Watch now! lnkd.in/dvHX7T4t
#PostgreSQL#PGDay #PPDD #AI #pgvector
Is synchronous replication really slow—or a silver bullet for zero data loss? 🤔 Alexander Kukushkin breaks down myths vs. reality. Learn when and how to use it right. ▶️ Watch now! www.youtube.com/watch?v=axkI...
#PostgreSQL #PGDay #PPDD #Replication #HighAvailability
#throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking 🚀 Dirk Krautschick shares hard-earned lessons▶️ Watch now! www.youtube.com/watch?v=aB5d...
#PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance
#throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo. Learn what really drives your plans. ▶️ Watch now! www.youtube.com/watch?v=qTtt...
#PostgreSQL #PPDD #QueryPlanning #DatabasePerformance
#throwback PostgreSQL on Kubernetes made practical ☸️ Vojtěch Mareš introduces CloudNativePG and shows how to run highly available Postgres on k8s. ▶️ Watch now! www.youtube.com/watch?v=ODWB...
#PostgreSQL #PGDay #PPDD #Kubernetes #CloudNativePG
#throwback From data swamp to data lakehouse 🏗️ Josef Machytka shares real-world lessons on building a lakehouse covering formats, scaling, governance, and data quality. ▶️ Watch now! www.youtube.com/watch?v=AUdE...
#PostgreSQL #PGDay #PPDD #DataLakehouse #DataEngineering
#throwback Struggling with downtime during schema changes? 🔒 Gulcin Yildirim Jelinek breaks down table-level locks. Learn how to avoid deadlocks and minimize impact.
▶️ Watch the talk now! www.youtube.com/watch?v=kKNZ...
#PostgreSQL #PGDay #PPDD #DatabaseLocks #ZeroDowntime
#throwback What really happens inside a PostgreSQL cluster after failover? 🔄 David Pech manually breaks down how tools like Patroni work.
▶️ Watch the video now! lnkd.in/dQiiBvXX
#PostgreSQL #PGDay #PPDD #Failover #HighAvailability
#throwback How does multi-master PostgreSQL really perform under pressure? 🔁 Alfredo Rodriguez shares a real-world case study.
▶️ Watch the talk now! www.youtube.com/watch?v=79ue...
#PostgreSQL #PGDay #PPDD #Replication #DatabaseEngineering
