2024-09-25 –, Junior Ballroom
Lace up your boots and let’s take a hike through your Postgres database internals. We’ll first step off the beaten path of the ORM and start our hike learning commands for interacting with the Postgres command line, psql. We’ll climb through some of Postgres’ system tables and special functions that tell you about your database from the inside. We’ll train your eyes on several important signs for debugging and knowing what’s going on inside your database. I’ll include special stops for looking at activity, queries, locks, and connections.
Exercising your Postgres skills on this tour will give you a leg up in working with your Django app and understanding performance related to your database. The guide will provide all the gear, necessary commands, and queries for your adventure. You don’t want to miss the view of your database when we get to the top. All skill levels are welcome.
Elizabeth writes about Postgres for Crunchy Data. She hosts the Kansas City Postgres User Group, organizes PostGIS Day, and is on the Board of the US PostgreSQL Association. Elizabeth speaks at Postgres events, open source events, and developer conferences. Elizabeth enjoys writing about Postgres for new users and teaching people about databases whenever she gets the chance. Elizabeth is from Lawrence, Kansas and spends most of her free time pretending like she lives on a farm in the 1860s.