How #PostgreSQL can help you enforce BEST PRACTICES

Talk recorded at FOSSCOMM 2023 @ Heraklion, Greece

Many systems have commonalities that lend themselves to similar best practices for administration and maintenance. Database systems in particular are complex and have many correctness, performance, and security considerations. In this talk, we will discuss PostgreSQL best practices, and how these translate to best practices in general. We will go over:
- Using the proper data types
- Controlling parallelization & transaction rate
- How locking affects performance
- Home-brewing Distributed Systems (don't)
- Choosing the right encoding
- Configuring for production usage
- Tracking resource usage
- Security good practices
- High Availability good practices
- The importance of upgrading & how to do it right

[ecognito]

In the talk you stated that pg_dump is not a backup, but never explained why. The first paragraph of the man page for pg_dump says, "pg_dump is a utility for backing up a PostgreSQL database, " which seems to disagree with you. ???