# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Intel White Paper on PostgreSQL with Memhive and Intel Optane Persistent Memory

Summary

Leverage Memhive to massively scale PostgreSQL performance using Intel Optane Persistent Memory. This guide provides comprehensive insights into leveraging PMEM’s full potential, detailing optimal configurations for features like persistent caching and fast Write-Ahead Logging (WAL). Designed for enterprises running mission-critical applications—such as financial, geo-data, or automotive platforms—the solution helps stabilize highly memory-intensive PostgreSQL instances, ensuring massive throughput boosts and operational reliability far beyond traditional hardware limits.

📄 Preview PAGE OF 6

Page 1 Text Content

Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory

WHITE PAPER

Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory

Table of Contents Summary .............................................................................................................................. 2 Challenges ............................................................................................................................ 2 What is Intel® Optane™ Persistent Memory? ....................................................................... 2 Scaling Postgre SQL with Memhive ....................................................................................... 3 Persistent Cache ............................................................................................................... 3 Fast WAL .......................................................................................................................... 3 PMEM-only mode .............................................................................................................. 4 PMEM Manager ................................................................................................................ 4 Testing Memhive with PMEM ................................................................................................ 4 Test Configurations ........................................................................................................... 4 Test Results ...................................................................................................................... 5 Conclusions .......................................................................................................................... 5

Page Summary Contents For Intel White Paper on PostgreSQL with Memhive and Intel Optane Persistent Memory

Page 1 Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory WHITE PAPER Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory Table of Co...
Page 2 Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory ➢ it is a complex task to manage them. For example, rebalancing shards to Summary avoid hotspots. ➢ joini...
Page 3 Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory eliminating the overheads of system calls, Memhive provides a cache which is entirely on device drivers, ...
Page 4 Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory continuity. Using PMEM for WAL significantly Testing Memhive with PMEM boots write performance as it elim...
Page 5 Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory Standard Memhive Postgres v12 Postgres Optane N/A 400 GB Persistent Cache DRAM 90 GB 90 GB • Figure 3 WAL...
Page 6 Whitepaper | Get the most out of Postgre SQL with Memhive and Intel® Optane™ Persistent Memory In conclusion, Memhive along with Intel Optane PMEM helps in scaling Postgre SQL to achieve significant i...

Manual Details

Brand Intel
Pages 6
File Size 320.45 KB
Published June 05, 2026
33 views

Enter the captcha to get the download link:

captcha

Frequently Asked Questions

What is Intel® Optane™ Persistent Memory?

It is a non-volatile, byte-addressable, low latency memory situated between DRAM and performance SSDs.

How does Memhive help scale PostgreSQL?

Memhive scales PostgreSQL by utilizing persistent cache and fast WAL features with Intel Optane PMEM.

Does using PMEM affect core PostgreSQL functionality?

No; only the storage backend of PostgreSQL is modified, leaving the rest (client-side, on-disk data structures, business logic) unmodified.

What benefits does sharding offer for databases like PostgreSQL?

Sharding partitions the tables across a cluster of instances, allowing horizontal scale-out to handle massive growth.