From Debugging Common Issues to Understanding the Optimizer

Kick off the summer with the PG Armenia Community at our next meetup on July 7! Join us next Monday evening for insights on Postgres debugging and a deep dive into the Query Optimizer.

🤝 We're excited to kick off our summer meetup series with our first in-person event, hosted by Webb Fontaine Armenia. Light snacks & drinks provided by Webb Fontaine and of course, a networking session at the end!

Talk 1: Debugging common PostgreSQL issues by Sargis Harutyunyan
💡In his talk, Sargis will share practical insights from PostgreSQL Mistakes and How To Avoid Them, highlighting the most common SQL and configuration errors developers face, and tips on how to fix or prevent them.

Talk 2: The Optimizer from Start to Finish by Bruce Momjian
💡The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the EXPLAIN command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can understand and perhaps improve its behavior.
💡The presentation covers the details of query optimization, optimizer statistics, joins, and indexes. It also covers 42 other operations the optimizer can choose to handle complex queries, large data sets, and to enhance performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.

🇺🇸 The language of the talks will be English.

Event Agenda:
6:15 pm - Doors Open
6:30 pm - 6:33 pm - Welcome
6:33pm - 6:55pm - Talk 1 + Q&A
6:55 pm - 7:40pm - Talk 2 part 1 + Q&A
7:40 pm - 7:45 pm - Break
7:45 pm - 8:10 pm - Talk 2 part 2 + Q&A
8:10 pm - 8:40 pm - Networking with food & drinks

Event details:
📅 July 7, 2025 at 6:15 PM
📍 Armenak Armenakyan ⅖, Webb Fontaine office, 6th floor (enter from the 1st entry, with stairs leading to the Synergy Business Center building)

➡️ RSVP on Meetup if you plan to attend this event.
✅ Please also complete this Google form: https://forms.gle/xE562vTdBmDZx89m7

✨ We look forward to seeing you there! 🤗

Emma Saroyan
Organizer, Armenia PUG 🚀