#performance
6 posts
Performance posts — profiling, measurement, and the surprises that appear when you actually look.
-
Postgres Concurrency Internals: Connections, Locks, and MVCC
A practical guide to how Postgres handles many concurrent clients — process-per-connection, pooling, lock manager, MVCC tuples, deadlocks, and pg_locks.
postgresqldatabaseconcurrencyinternalsperformance -
Postgres Partitioning: Strategies, Real Advantages, and Pitfalls
A practical guide to PostgreSQL partitioning — RANGE, LIST, HASH, pruning, local indexes, real advantages, and the pitfalls that bite in production.
postgresqldatabaseperformanceinternals -
PostgreSQL Indexing: Internals, Types, and Trade-offs
A practical guide to PostgreSQL indexes: B-tree, GIN, GiST, BRIN, hash — when to use each, composite key ordering, and CONCURRENTLY pitfalls.
postgresqldatabaseperformanceinternals -
Go Profiling: From pprof to Flame Graphs
A practical guide to CPU, heap, goroutine, and trace profiling in Go — when to use each tool, how to wire it into a service, and how to read the output.
goperformancedebugging -
PostgreSQL EXPLAIN: Reading and Understanding Query Plans
How to read PostgreSQL EXPLAIN output: scan types, join algorithms, and the cost model — turn opaque query plans into actionable insights.
postgresqldatabaseperformancesql -
How Databases Actually Store and Find Your Data
A bottom-up look at how databases physically store data — pages, heaps, B-trees, clustered indexes, and row IDs.
databaseinternalsperformance