Log an issue
Fork and edit
Discuss on Discord
Introduction
Before and after tuning PostgreSQL
System, Kernel, compiler, and Libraries
Tuning PostgreSQL
Testing PostgreSQL Tunings
Review
Next Steps
You should now know how to:
When tuning a worker process or thread count configuration parameter. What can often be a good starting value?
What is the recommended size for the PostgreSQL shared buffer?
Enabling huge pages helps performance by increasing shared buffer hit rate.
You need to answer each question to see the results.