Tech Notes

Tech Notes

Tech tips and new discoveries

All Posts#Architecture#CSS#Database#Databases#Docker#Finance#Homelab#JavaScript#Linux#Networking#Node.js#Performance#PostgreSQL#Project#React#TypeScript#Ubuntu
Why Databases Reach for B+ Trees

Why B+ trees became the default on-disk index structure for relational databases, and where they do not work well.

DatabasesPostgreSQLPerformance
Read More
Reading PostgreSQL Execution Plans with EXPLAIN ANALYZE

How I read EXPLAIN ANALYZE output in PostgreSQL: node types, bad row estimates, and how to use the plan to fix a query.

PostgreSQLDatabasesPerformance
Read More