Linux tuning to improve PostgreSQL performance
Linux operating system has lots of tuning options which can change performance of your PostgreSQL installation drastically. For PostgreSQL, obviously, most important are storage-related options like vm.dirty*, IO elevators or filesystem mount options, but there are many more of them: CPU scheduler options, NUMA settings, or even power saving policy. The goal of this talk is to explain to DBAs and engineers how to use all this settings in order to match hardware configuration and PostgreSQL workload.
CEO / Adviser
CEO and adviser in PostgreSQL-Consulting LLC, specialist on PostgreSQL, Oracle, DB2 databases.