Karen Jex: Tinh chỉnh PostgreSQL để hoạt động tốt hơn nữa (PGConf.EU 2023)

We all know that Postgres is a popular database for many different applications. Developers love the fact that Postgres "just works" out of the box. On the other hand, the default parameter values aren't always right for production, and you might not have a DBA on hand to configure them for you.

Fortunately, you don't need to learn about all 350+ Postgres parameters to get the most out of your database. We'll look at the most important settings, and give some rules of thumb for tuning them according to your use-case, to make sure your database performs at its best. Then you can leave Postgres to "just work", and you can focus your efforts on developing your application.