article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

cat /proc/meminfo | grep -i huge AnonHugePages: 0 kB ShmemHugePages: 0 kB HugePages_Total: 88 HugePages_Free: 88 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB Now set the parameter huge_pages “on” in $PGDATA/postgresql.conf and restart the server. $

Tuning 56
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. Now let’s stretch our imagination and consider a second method of high availability, ala Citus.

C++ 80
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