What you've learned

You should now know how to:

  • Tune PostgreSQL to increase performance

Knowledge Check

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.