#postgresql

3 articles

Databases July 28, 2026 · 10 min read

Postgres Index Types Explained: B-tree, GIN, BRIN, and the Operators That Pick Them

A practical tour of PostgreSQL index types with real query plans: how B-tree, GIN, and BRIN work, what operator classes are, and how the operators in your WHERE clause decide which index you need.

#postgresql #indexes #performance

Databases July 27, 2026 · 10 min read

Postgres JSON vs JSONB: Storing Data Chunks for AI Processing

The real differences between JSON and JSONB in PostgreSQL, how each one stores your data, when plain JSON wins, and how JSONB earns its place holding chunk metadata in an AI pipeline.

#postgresql #jsonb #json

Databases October 16, 2025 · 18 min read

PostgreSQL Mistakes You're Probably Making (And How to Fix Them)

A comprehensive guide to avoiding common PostgreSQL pitfalls that can compromise performance, data integrity, and maintainability.

#postgresql #databases #sql