#PostgreSQL Articles - NextGenBeing

Web Development 15 min read

Postgres JSONB vs Separate Tables: Real Benchmarks

Change one integer inside an 8 KB JSONB document and PostgreSQL 17 writes about 16,300 bytes of WAL. Change the same integer when it lives in its own column and it writes 294 bytes. That 55x gap…

#PostgreSQL #Performance #Database Design

Oct 01, 2026

PostgreSQL Hidden Features for Better Performance: Battle-Tested Optimizations from Production

Discover PostgreSQL's overlooked performance features that reduced our query times by 85% and saved $12k monthly in infrastructure costs. Real benchmarks, production patterns, and gotchas included.

#PostgreSQL #Performance #Optimization

May 23, 2026

PostgreSQL Partial Index vs BRIN vs Expression Index: Measured on 3M Rows

Reproducible benchmarks of a PostgreSQL partial index, BRIN index, expression index and INCLUDE index on 3M rows, with sizes, plans and when each does nothing.

#PostgreSQL #Performance #SQL

Apr 19, 2026