Sign in

Prague PostgreSQL Developer Day

@praguepgdevday.bsky.social
27 followers 3 following 71 posts

A community conference in Prague, organized by CSPUG.

PostsRepliesMedia
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 29/01/2026
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! 🇨🇿💙
032
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Fuzzing PostgreSQL at the front door 🔍Adam Wołk shows how it uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, harden Postgres networking code against real-world failures. p2d2.cz/en/talks/kno... #libpq #Fuzzing #DatabaseSecurity #OpenSource #DBA #DeveloperTools
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
“It works on my database” 😅 Radim Marek shows why that’s not enough. Learn how RegreSQL brings PostgreSQL-style regression testing to application SQL. lnkd.in/dDCE5VHu #PostgreSQL #P2D2 #P2D2 #SQL #Testing #RegressionTesting #DatabaseDev
141
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Observability beyond the database. ☁️ Peter Zaitsev Percona Coroot explores cloud-native Postgres monitoring—from client apps to VMs, storage, and networks. Learn to track Postgres in dynamic cloud environments. p2d2.cz/en/talks/clo... #PostgreSQL #P2D2 #Observability #Cloud
022
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Vacuum horror stories don’t have to end badly. 🧹 Robert Treat dives into large-table vacuuming, XID wraparound incidents, recent Postgres improvements that make mission-critical workloads safer. p2d2.cz/en/talks/a_b... #PostgreSQL #P2D2 #Vacuum #Internals
031
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
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. p2d2.cz/en/talks/a_b... #PostgreSQL #P2D2 #Performance
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
“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. #PostgreSQL #P2D2 #OLTP #Performance
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
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. lnkd.in/d_QD95ZG #PostgreSQL #P2D2 #PGScale #Databases
031
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
PostgreSQL 18 brings big upgrades to constraints! 🔒 Gülçin Yıldırım Jelínek Xata.io 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. lnkd.in/d_xZ6HD2 #PostgreSQL #P2D2 #PG18 #DataIntegrity
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Incredible Lightning Talks at P2D2 hosted by Pavlo Golub! ⚡ Our taleted speakers showcased projects in under 5 mins. Huge thanks to Mayuresh, Michal, Sergey, Alijaz, Josef, Hettie, Ants, Jonathan, Ellyne, Mohsin, Anton, Luigi 🙌 Slides: lnkd.in/dfRNUYeQ #P2D2 #PostgreSQL #LightningTalks
021
Reposted by Prague PostgreSQL Developer Day
EDB @edbpostgres.bsky.social · 28/01/2026
We're having great conversations at P2D2! Did you join Bruce Momjian's presentation on what's missing in #PostgreSQL? How about the workshop on @cloudnativepg.bsky.social by Jonathan Battiato and Danish Khan? Come find us at our booth at @praguepgdevday.bsky.social 👋
Bruce Momjian presenting to an auditorium at P2D2Jonathan Battiato, Danish Khan, Pinaz Raut, Markus Wanner, and Bruce Momjian, behind the EDB Postgres AI booth filled with swag.Jonathan Battiato pointing at his slide. People sit in classroom setting facing Jonathan so we only see their backs and an occassional laptop screen.
032
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
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. #PostgreSQL #TimescaleDB #IoT #P2D2
031
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
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! #PostgreSQL #ORM #Go #P2D2
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
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! #PostgreSQL #Performance #P2D2
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Help us collect attendee stats for P2D2 and support our sponsors 🙌 Fill in our short form and you’ll be entered into a draw to win one of 3 copies of Jimmy Angelakos's book "PostgreSQL Mistakes and How to Avoid Them” 📘🎉 Survey link: p2d2.cz/stats #P2D2 #PostgreSQL #Community #Giveaway
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Don’t forget the hallway track ☕️🤝 That’s where great coffee meets sponsor booths, spontaneous Postgres chats, and reconnecting with old friends—or making new ones. Some of the best insights happen between the talks! #P2D2 #PostgreSQL #HallwayTrack #PostgresCommunity
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Special guest spotted at #P2D2 👀🐘 Our Slonik mascot made a surprise appearance, spreading good vibes, Postgres pride, and a few smiles around the venue. Turns out even elephants love a great PostgreSQL conference! 💚 #PostgreSQL #Slonik #PostgresCommunity
041
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Zero downtime, zero drama. Anton Borisov shares how Fresha upgraded dozens of PostgreSQL clusters from 12 → 17 using logical replication, PgBouncer choreography, and blue-green switches—without breaking traffic or CDC. p2d2.cz/en/talks/swi... #PostgreSQL #P2D2 #Upgrades #DevOps
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
PostgreSQL evolves fast—yet some big features are still missing. Bruce Momjian explores why sharding, TDE, global indexes, and multi-master replication aren’t in Postgres (yet), and what that means for the future. p2d2.cz/en/talks/wha... #PostgreSQL #P2D2
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
SQL injection is just the beginning. Kranthi Kiran Burada & Narendra Tawar uncover advanced PostgreSQL threats—from FDW abuse and side channels to logical replication misuse and RLS pitfalls. lnkd.in/duc7FPyD #PostgreSQL #Security #P2D2
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
How do B-tree indexes really work—and how should you tune them today (and tomorrow)? Jakub Kužela dives into index access paths, skip scans, automated indexing, and the future of self-tuning databases. lnkd.in/dczDjfA8 #PostgreSQL #Indexes #Performance #P2D2
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Do you really need Kafka for every queue? 🤔 Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. lnkd.in/dSrpHGmJ #PostgreSQL #PgQ #P2D2 #EventDriven #Databases
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
How do you really clean up PostgreSQL at scale? 🧹🐘 Çağrı Biroğlu dives into autovacuum internals, safe deletion patterns, and avoiding vacuum storms in high-concurrency systems. lnkd.in/dh6SKhJ9 #PostgreSQL #P2D2 #Autovacuum #Internals #Performance
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 28/01/2026
Kicking off P2D2 with a packed morning! 🚀 Tomas Vondra opened the day with the introduction as we return to this venue for the 11th year. 320 attendees and lots of Postgres energy in the room—are you excited for the day ahead? 🐘✨ #P2D2 #PostgreSQL #PGDay #PostgresCommunity #Prague #TechConference
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 27/01/2026
Hands-on monitoring at P2D2! 🐘 Pavlo Golub led pgwatch: From Zero to Hero!, guiding attendees through setup, connecting PostgreSQL instances and more. Practical tips for production-ready Postgres monitoring. #PostgreSQL #P2D2 #pgwatch #Monitoring #Grafana #DBA #PostgresOps #OpenSource
031
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 27/01/2026
Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns and more. Learn how to scale and optimize your Postgres connections! #PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 27/01/2026
📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘 #PostgreSQL #QueryOptimization #DatabasePerformance
031
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 27/01/2026
🚀 Day 1 at #P2D2 — workshops happening this morning: PostgreSQL Query Optimization (Hettie Dombrovskaya), Running PostgreSQL in #Kubernetes with #CloudNativePG (Jonathan & Danish), and Introduction to Postgres Hacking (Tomas Vondra, Nazir Bilal Yavuz). ☕🐘 #PostgreSQL #P2D2 #Workshops #Training
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 26/01/2026
Our Prague PostgreSQL Meetup was a hit! 🎉 Teresa Lopes, Josef Machytka & Luigi Nardi shared insights on Postgres at scale, high-speed pipelines & AI in databases. Great discussions and networking ahead of P2D2 2026! #PostgreSQL #PGDay #P2D2 #TechCommunity
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 26/01/2026
📍 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: lnkd.in/eTmWGmvb
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 26/01/2026
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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 26/01/2026
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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 26/01/2026
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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 26/01/2026
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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 23/01/2026
⚡️ 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
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 22/01/2026
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
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 22/01/2026
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
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 22/01/2026
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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 20/01/2026
#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
021
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 20/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 20/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 20/01/2026
Welcome EDB, our Gold Sponsor for P2D2 2026! Thank you for supporting the community! 🙌 Visit them here: www.enterprisedb.com #P2D2 #PostgreSQL #TechEvents #OpenSource #GoldSponsor #PragueTech
042
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 19/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 19/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 18/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 18/01/2026
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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 18/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 18/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 16/01/2026
#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
011
Prague PostgreSQL Developer Day @praguepgdevday.bsky.social · 16/01/2026
#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
021