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