Remove 2048 Remove Hardware Remove Speed Remove Tuning
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. 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 58
article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. The same can be said for Citus data sharding. citus_columnar | 11.1-1 1 citus | 11.1-1

C++ 83
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

ReadFile WriteFile ReadFileScatter WriteFileGather GetOverlappedResult ​​ For extended details on the 823 error, see ​​ Error message 823 may indicate hardware problems or system problems ​​ ( [link] i crosoft.com/default.aspx?scid=kb ​​ Contact your hardware manufacture for assistance.

Servers 40