Practical Query Optimization in Postgres: Indexes, Partitioning, and Plan Introspection
Learn how to speed up Postgres queries with B-tree indexes, table partitioning, and EXPLAIN ANALYZE. Step-by-step with real Python code.
03 / NOTES FROM THE FIELD
Practical engineering notes, written as I work through the details. Queries, pipelines, Python, and the trade-offs behind them.
ESSAYS, GUIDES & ENGINEERING NOTES
Learn how to speed up Postgres queries with B-tree indexes, table partitioning, and EXPLAIN ANALYZE. Step-by-step with real Python code.
Learn how to build reliable ML feature pipelines in Python: ingestion, transformation, storage, and serving — with Docker and pytest.
Profile Python pipelines, replace slow loops with NumPy vectorization, and safely parallelize I/O with ThreadPoolExecutor. Step-by-step with Docker.