Linux tuning to improve PostgreSQL performance

Опубликовано: 01 Октябрь 2024
на канале: Southern California Linux Expo

2,033

Streamed live on Jan 21, 2016

Talk by Ilya Kosmodemiansky

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.

More info at: http://www.socallinuxexpo.org/scale/1...