Percona

AUGUST 29, 2018

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 79

Tuning Database Servers Processing 79

Percona

AUGUST 29, 2023

Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. Can you think of a better system that can stay up without losing time initiating failovers when a node fails? Now let’s stretch our imagination and consider a second method of high availability, ala Citus. citus_columnar | 11.1-1

C++ 98

C++ Database Storage Testing 98

SQL Server According to Bob

JANUARY 11, 2020

​​ 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

Servers Cache Database Media 40