Schedule - PGConf NYC 2023

How PostgreSQL Can Help You Enforce Best Practices

Date: 2023-10-05
Time: 10:40–11:30
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

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

Slides

The following slides have been made available for this session:

• https://vyruss.org/computing/slides/pgconfnyc2023_how_postgresql_can_help_you_enforce_best_practices

Speaker

Jimmy Angelakos