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. There are no “good” values for these two parameters since both depend on the hardware. Poorly configured OS kernel parameters can cause degradation in database server performance.

Tuning 54
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