
Before we start
•
269 settings in version 10
•
314 so far in version 12
•
Settings in postgresql.conf are to be change manually
•
postgresql.auto.conf can be changed only through ALTER
SYSTEM
•
pg settings view combines everything together
dataegret.com
Why this talk
• Linux is a most common OS for databases
• DBAs often run into IO problems
• Most of the information on topic is written by kerneldevelopers
(for kernel developers) or is checklist-style
• Checklists are useful, but up to certain workload
dataegret.com
评论