DjangoCon Europe 2023 | Tuning PostgreSQL to work even better

Tuning PostgreSQL to work even better by Karen Jex https://pretalx.com/djangocon-europe-2023/talk/BT7XGG/

PostgreSQL "just works" as a database for your Django applications, but with knowledge of a handful of configuration parameters, you can make it work even better!

PostgreSQL is a popular database for Django applications. One of the things developers like about PostgreSQL is that it "just works". This is great news; it lets you focus on what you do best - developing applications. On the other hand, the default PostgreSQL parameter values might not be right for your production database. Fortunately, you don't need to learn about all 365 PostgreSQL parameters to get the most out of your database. A working knowledge of just a handful of parameters could make a big difference. We'll take a look at the most important PostgreSQL parameters, and give some rules of thumb for tuning them according to your use-case. You will come away knowing what these parameters do, why they're important, and how to set them so your PostgreSQL database performs at its best. And then you can leave PostgreSQL to "just work", and you can focus all your efforts on developing your application.

Date Added: September 19, 2024