Smart Queries, Secure Databases | 360 Degree View of Postgres Security

🎉 Mark your calendars! Join us for an exciting deep dive into PostgreSQL Performance & Security! 🐘

💡 Optimizing query performance and securing databases are two critical yet often overlooked aspects of database management. In her presentation, Smart Queries, Secure Databases: Selectivity Estimation & PostgreSQL Security Best Practices, Liana will dive into the concept of selectivity estimation, a crucial mechanism in PostgreSQL that influences query planning and execution efficiency. We’ll explore how PostgreSQL estimates query costs, the impact of inaccurate selectivity estimation, and practical techniques to optimize performance.

💡 Beyond query optimization, security is a core concern in database management. Gain insights into how selectivity estimation and security intersect, ensuring both efficient and secure database operations. In her session, she will also cover key PostgreSQL security best practices, from authentication and access controls to encryption and auditing.

🚀 Whether you're a data professional, engineer, or security enthusiast, this talk will equip you with practical knowledge to enhance both the speed and security of your PostgreSQL databases.

👩‍💻 In the online session, 360 Degree View of Postgres Security, Elizabeth from Crunchy Data, will walk us through the core building blocks of securing a Postgres database. There are many ways to secure Postgres, from the code itself, to individual user permissions, the on-disk storage, traffic to/from the database, and more. In this session, you’ll learn about roles and permissions, encryption options, and common configuration best practices to reduce risk. This session will leave you with a practical checklist to review security across your deployments. ☑️

🚀 This talk will equip you with insights, best practices, and expert tips!

🇺🇸 The language of the talks will be English.

🗓️ Agenda:
4:30 PM - Doors open
4:45 PM - 5:15 PM - Liana’s Speech
5:15 PM - Coffee Break
5:30 PM - 6:00 PM - Elizabeth's Speech (Online)
6:00 PM - 6:15 PM - Q&A
6:15 PM - 8:00 PM - Networking with Food 🍕& Drinks 🧃 (Sponsored by Google Women Techmakers)

Event details:
📅 April 26th, 2025 at 4:30 PM
📍 Armenian Code Academy (Yerevan, 3 Hakob Hakobyan)
➡️ RSVP on Meetup if you plan to attend this event.
✅ Please also complete this Google form: https://forms.gle/xE562vTdBmDZx89m7

✨ We’re looking forward to seeing you there!

Emma Saroyan,
Armenia PostgreSQL User Group Organizer 🚀