PostgreSQL Tutorial: Enabling Linux Huge Pages
Summary: Using Huge Pages reduces the memory page table size of PostgreSQL processes and cuts down CPU overhead spent on memory management, thereby improving overall database performance.
Redrock Postgres
The world's best
PostgreSQL database.
Cloud Native Storage Engine
- Fully compatible with PostgreSQL
- Separate storage and compute components
From our blog
News, articles, customer success stories, and tutorials on PostgreSQL, open source, Redrock Postgres, and more.
PostgreSQL Tutorial: Tuning I/O Performance with pg_stat_io
Summary: In this tutorial, you will learn about pg_stat_io view, including byte-level I/O statistics, WAL tracking, and comprehensive real-world use cases for better database performance tuning.
Freeze caused by high transaction throughput in PostgreSQL
Summary: In this article, we’ll take a look at the freeze issue that comes with high transaction throughput in PostgreSQL, and corresponding solutions.
Performance Impact of Exception Logic in PostgreSQL Stored Procedures
Summary: Developers often use exception handling in stored procedures, especially when migrating from other databases to PostgreSQL, but the behavior varies greatly between different databases.
Copyright (c) 2017 - 2025, Redrock Data Services, Inc. All rights reserved.