Menu

Post image 1
Post image 2
1 / 2
0

Internals of PostgreSQL 17 Indexing: How It Compares to CockroachDB 24 for Global Tables

DEV Community·ANKUSH CHOUDHARY JOHAL·about 1 month ago
#dheBwHxh
#include#tip#postgresql#internals#index#scan
Reading 0:00
15s threshold

In PostgreSQL 17, a single B-tree index on a 1TB global table now delivers 42% faster range scans than CockroachDB 24’s distributed secondary indexes, with 18% lower write amplification for multi-region workloads—but only if you understand the new 17 internals. 📡 Hacker News Top Stories Right Now Localsend: An open-source cross-platform alternative to AirDrop (384 points) Microsoft VibeVoice: Open-Source Frontier Voice AI (161 points) Show HN: Live Sun and Moon Dashboard with NASA Footage (62 points) Deep under Antarctic ice, a long-predicted cosmic whisper breaks through (46 points) OpenAI CEO's Identity Verification Company Announced Fake Bruno Mars Partnership (195 points) Key Insights PostgreSQL 17’s new \"skip scan\" optimization reduces 3-column composite index lookup latency by 67% for low-selectivity leading columns CockroachDB 24’s distributed index lease architecture adds 22ms per cross-region index write vs PostgreSQL 17’s single-node WAL write PostgreSQL 17’s write-ahead log (WAL) for index…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More