Remove 2048 Remove Operating System Remove Systems Remove Tuning
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. In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. PostgreSQL uses System V (SysV) that requires SHMMAX setting.

Tuning 55
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40