Remove 2048 Remove Database Remove Operating System Remove Servers
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. Poorly configured OS kernel parameters can cause degradation in database server performance. PostgreSQL uses System V (SysV) that requires SHMMAX setting. SHMMAX / SHMALL. Until version 9.2,

Tuning 56
article thumbnail

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

If my memory serves me correctly SQL Server started using the ReadFileScatter and WriteFileGather APIs in SQL Server 6.5 On Linux the capabilities are called “ Vectored I/O.” – Example writev SQL Server on Linux takes full advantage of vectored I/O, retaining the performance and design benefits.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40