Remove 2048 Remove Operating System Remove Speed Remove Systems
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. PostgreSQL uses System V (SysV) that requires SHMMAX setting. So now it requires fewer bytes of System V shared memory. DETAIL: Failed system call was shmget(key=1, size=2072576, 03600).

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