article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. You need to set a value of vm.dirty_background_bytes depending on your disk speed. Poorly configured OS kernel parameters can cause degradation in database server performance. Script to quantify Huge Pages. /bin/bash

Tuning 57
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Subsystem / Path The ​​ I/O subsystem or path ​​ includes ​​ those ​​ components ​​ that are ​​ used to support an I/O operation. ​​ Also, it ​​ is ​​ generally impractical on a production system.

Servers 40