Remove 2048 Remove Hardware Remove Operating System Remove Speed
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. There are no “good” values for these two parameters since both depend on the hardware.

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