Prague PostgreSQL Developer Day
LightNews LightNews
praguepgdevday.bsky.social
Prague PostgreSQL Developer Day
@praguepgdevday.bsky.social
17 followers 2 following 37 posts
A community conference in Prague, organized by CSPUG.
Posts Replies Media Videos
praguepgdevday.bsky.social
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
January 22, 2026 at 10:44 AM
praguepgdevday.bsky.social
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
January 22, 2026 at 10:42 AM
praguepgdevday.bsky.social
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
January 22, 2026 at 10:41 AM
praguepgdevday.bsky.social
#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
January 20, 2026 at 2:22 PM
praguepgdevday.bsky.social
#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
January 20, 2026 at 2:20 PM
praguepgdevday.bsky.social
#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
January 20, 2026 at 2:18 PM
praguepgdevday.bsky.social
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
January 20, 2026 at 10:25 AM
praguepgdevday.bsky.social
#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
January 19, 2026 at 8:56 AM
praguepgdevday.bsky.social
#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
January 19, 2026 at 8:55 AM
praguepgdevday.bsky.social
#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
January 18, 2026 at 7:14 PM
praguepgdevday.bsky.social
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
January 18, 2026 at 9:49 AM
praguepgdevday.bsky.social
#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
January 18, 2026 at 9:48 AM
praguepgdevday.bsky.social
#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
January 18, 2026 at 9:47 AM
praguepgdevday.bsky.social
#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
January 16, 2026 at 9:37 AM
praguepgdevday.bsky.social
#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
January 16, 2026 at 9:33 AM
Reposted by Prague PostgreSQL Developer Day
boringsql.com
Test if queries hit the right indexes at production scale – without needing to have production data.

I'll show you exactly how during @praguepgdevday.bsky.social - Session "It works on my database - Regression testing of SQL queries" is last of the day, but I intend to make it worth staying for.
January 14, 2026 at 10:27 PM
praguepgdevday.bsky.social
#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
January 16, 2026 at 9:28 AM
praguepgdevday.bsky.social
#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
January 14, 2026 at 1:10 PM
praguepgdevday.bsky.social
#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
January 13, 2026 at 12:10 PM
praguepgdevday.bsky.social
Welcome GoPay, our Bronze Sponsor for P2D2 2026! Thank you for supporting the community! 🙌

Visit them here: gopay.com

#P2D2 #PostgreSQL #TechEvents #OpenSource #BronzeSponsor #PragueTech
January 12, 2026 at 8:33 AM
praguepgdevday.bsky.social
Welcome Outreach, our Silver Sponsor for P2D2 2026! Thank you for supporting the community! 🙌

Visit them here: outreach.io

#P2D2 #PostgreSQL #TechEvents #OpenSource #SilverSponsor #PragueTech
January 12, 2026 at 8:32 AM
praguepgdevday.bsky.social
Welcome AWS, our Gold Sponsor for P2D2 2026! Thank you for supporting the community! 🙌

Visit them here: aws.amazon.com

#P2D2 #PostgreSQL #TechEvents #OpenSource #GoldSponsor #PragueTech
January 12, 2026 at 8:32 AM
praguepgdevday.bsky.social
Welcome Mib.dima, our Bronze Sponsor for P2D2 2026! Thank you for supporting the community! 🙌

Visit them here: mibdima.cz

#P2D2 #PostgreSQL #TechEvents #OpenSource #BronzeSponsor #PragueTech
December 28, 2025 at 12:35 AM
praguepgdevday.bsky.social
Welcome Septim Systems a.s., our Bronze Sponsor for P2D2 2026! Thank you for supporting the community! 🙌

Visit them here: www.septim.cz/en

#P2D2 #PostgreSQL #TechEvents #OpenSource #BronzeSponsor #PragueTech
December 28, 2025 at 12:33 AM
praguepgdevday.bsky.social
Welcome TeepCo, our Bronze Sponsor for P2D2 2026! Thank you for supporting the community! 🙌

Visit them here: teepco.cz

#P2D2 #PostgreSQL #TechEvents #OpenSource #BronzeSponsor #PragueTech
December 18, 2025 at 1:36 AM