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
As presented at DjangoCon US 2023-10-16
Video recording: https://2023.djangocon.us/talks/how-to-ride-elephants-safely-working-with-postgresql-when-your-dba-is-not-around/