梦兽编程^™

[ SECTION / INFRASTRUCTURE ]

PostgreSQL

Practical PostgreSQL articles on database design, performance, indexing, and new capabilities.

6 POSTS

This section covers PostgreSQL design and practice: queries and indexes, performance analysis, caching, vector search, and new-version capabilities. Articles focus on conditions, trade-offs, and verifiable implementation details.

INFRASTRUCTURE / 2026.04.17 / 9 MIN PostgreSQL 18 UUIDv7: Your Indexes Can Finally Breathe PostgreSQL 18 brings native UUIDv7 support with 50% index performance improvement. Say goodbye to UUIDv4 fragmentation and get primary keys that are both ordered and … ↗ 02

INFRASTRUCTURE / 2026.02.25 / 7 MIN PostgreSQL 18 Asynchronous IO Revolution: Why This Is the Biggest Database Update in 5 Years PostgreSQL 18's asynchronous IO with io_uring delivers 3.4x faster sequential scans, 2.1x faster index scans. Real benchmark data, configuration guide, and migration … ↗ 03

INFRASTRUCTURE / 2026.02.09 / 10 MIN PostgreSQL 18 Benchmark Data: I Said You Could Kill Your Redis Cache Layer. You Didn't Believe Me. Real benchmark data for PostgreSQL 18: async IO + skip scan deliver a massive database performance leap. Production test with 1K concurrent users shows P95 latency … ↗ 04

INFRASTRUCTURE / 2026.02.03 / 5 MIN PostgreSQL Query Parsing Too Slow? PgDog Ditched Protobuf and Got 5x Faster PgDog is a Rust-based PostgreSQL proxy. They discovered Protobuf serialization was the real bottleneck in SQL query parsing — not the Postgres parser itself. By replacing … ↗ 05 // INFRASTRUCTURE / 2025.12.27 / 9 MIN PostgreSQL 18 vs Redis: The Day I Realized Our Cache Layer Was Optional PostgreSQL 18's async IO and skip scan made our database so fast that Redis caching became optional. Three engineers independently deleted 4,000+ lines of cache code in a … ↗ 06

INFRASTRUCTURE / 2025.01.31 / 4 MIN pgvector 0.8.0 Is Here: Do You Still Need a Dedicated Vector Database? Your CTO approved a $50k Pinecone contract. An intern added vector search to your existing PostgreSQL for free in 47 minutes. pgvector 0.8.0's iterative scans and smart … ↗