Utah Postgresql Meetup --Postgres Design Choices and Affect of Storing Data

Presented at the Utah Postgresql Meetup on 04-26-22

Title: Postgres Design Choices and Affect of Storing Data

I will present some of Postgres's design choices and how they affect storing data. Once engineers understand Postgres at this level, other higher-level decisions make more sense, like specific table structures and queries.

We’ll do a workshop where we'll explore Postgres' data files. Of course, you're welcome to listen, but I think you'll get more out of it if you follow along on your machines. So to maximize our time, I need you to be prepared if you plan to follow along.

You'll need Postgres installed locally or in Docker and some way to query the database. In addition, you'll need oid2name and hexdump where Postgres lives. If you don’t already have hexdump, the easiest way is to install it via your package manager, such as brew or apt.

We'll need to access Postgres' data directory, so make sure you have access. You may need to SUDO as root to do this by running `sudo su -`

Bio:
Brian Broderick
I once asked, out loud, “What is a database? And why would I ever need to use one?” Little did I know then that they would define my career for the next two decades.
Other interests include woodworking, hiking, and looking for something good to stream on TV.