2024-08-03, 10:45–11:15 (Asia/Taipei), TR409-2
Every so often, one may be called upon to perform the tasks of a database administrator, especially in cases where application performance seems to be affected by the database. This talk will give non-DBAs an insight into how the world’s most powerful open-source database works, and the kind of tools and features that are readily available for people who unexpectedly find themselves in the DBA pilot’s seat. Topics covered will include query tuning, monitoring, indexing, and a basic run-down of some configurables to help you know what options are at your disposal
This conference presentation caters to individuals occasionally thrust into the role of a database administrator, particularly when application performance is at stake due to database intricacies. Geared towards non-DBAs, the talk provides a comprehensive overview of the world's most powerful open-source database, PostgreSQL, offering insights into its functionalities and the array of tools available for those unexpectedly steering the DBA ship.
The content revolves around key areas essential for non-DBAs finding themselves in the DBA pilot's seat:
-
Query Tuning: Unpacking the nuances of query performance, this section equips attendees with strategies to enhance application speed and efficiency. Practical tips for optimizing queries in PostgreSQL will be explored, empowering non-DBAs to navigate this critical aspect of database management.
-
Monitoring: Delving into the realm of monitoring, the presentation sheds light on tools and features that aid in keeping a vigilant eye on database performance. Attendees will gain insights into monitoring techniques, allowing them to identify and address potential issues proactively.
-
Indexing: Understanding the importance of indexing in a database is crucial for effective data retrieval. The talk covers the basics of indexing in PostgreSQL, offering non-DBAs a practical understanding of how to leverage this feature for improved application performance.
-
Configurables Overview: Providing a basic run-down of configurable options, the presentation ensures that non-DBAs are aware of the available choices to tailor PostgreSQL to specific needs. This includes an exploration of key configuration parameters and their impact on database behavior.
The overarching goal is to demystify PostgreSQL for non-DBAs, enabling them to navigate common challenges associated with database administration. By the end of the session, attendees will have gained valuable insights into query tuning, monitoring best practices, indexing essentials, and a fundamental understanding of PostgreSQL configurables. This knowledge equips non-DBAs with the tools they need to confidently manage and optimize PostgreSQL databases when the unexpected DBA responsibilities arise.
Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Software Engineer and Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial institutions.