Schedule - PGConf.EU 2023
Charting My Path: Journey of a GSoC 2023 Contributor to PostgreSQL with pg_statviz
Join me on a captivating journey as I share my experience as a fresh contributor to the PostgreSQL community during Google Summer of Code 2023. In this talk, I'll dive into the heartwarming support that I received when embarking on my open-source adventure. Through my contributions to the project, 'pg_statviz', I will explore the process, challenges, and triumphs that marked my initiation into the world of PostgreSQL. The PostgreSQL community is renowned for its vibrant and welcoming nature, and I'll be your guide to showcasing just how true this reputation is. I'll be talking about the help I recieved from the developers and community members, and how this effort made my path of contribution and learning easier. Central to my presentation is the 'pg_statviz' tool, a minimalist tool I was happy to help make better during my GSoC project. I will provide a comprehensive overview of its functionalities, detailing how it offers database administrators and developers insights into PostgreSQL by storing data and statistics about PostgreSQL. Crafted with the purpose of capturing both cumulative and dynamic statistics within PostgreSQL, this toolset offers the capability to engage in insightful time series analysis. Its companion utility is adept at generating visually engaging representations, honing in on specific time intervals extracted from the stored statistical snapshots. This empowers users with the ability to monitor the performance of PostgreSQL over time, opening doors to potential optimization and troubleshooting requirements.