June 2025
- Jun 12, 2025ExplainersHow Database Indexes Improve Query PerformanceLeis and colleagues evaluated PostgreSQL alongside commercial systems and found estimation errors drove the planner to pick query plans 10 to 100 times slower than optimal, so a correct index can still go unused. The structural case for indexes remains overwhelming: with a branching factor of 500, a B-tree reaches 62.5 billion rows in four levels. This page covers clustered versus non-clustered, covering indexes, BRIN, the write penalty and reading EXPLAIN output.
- Jun 11, 2025ExplainersUnderstanding Database Transactions and ACID RulesTransferring $500 means debiting one account and crediting another. If the system crashes between the two, the money either vanishes or is created from nothing, and both break the invariant that total money stays constant. A transaction wraps the writes so they all commit or all roll back. ACID, coined by Theo Haerder and Andreas Reuter in 1983 on Jim Gray's work, names four interlocking guarantees: remove one and corruption, violated constraints or lost commits follow.
February 2023
No guides match that search. Try a shorter phrase, or clear the search.