Databases · Failures and antipatterns
Database lock timeouts
Distinguish lock-acquisition deadlines from statement deadlines and connect blocker investigation with failed-transaction and retry handling.
IntermediateSEARCH LAVACS
Search textbooks, study guides, six encyclopedias, experiments and comparisons.
60 results · page 2 of 3
Databases · Failures and antipatterns
Distinguish lock-acquisition deadlines from statement deadlines and connect blocker investigation with failed-transaction and retry handling.
IntermediateDatabases · Failures and antipatterns
Use a balance example to compare atomic updates, version predicates and transaction-level conflict handling.
IntermediateDatabases · Failures and antipatterns
Find query amplification across a request and compare joins, batching and their data-shape tradeoffs.
IntermediateDatabases · Failures and antipatterns
Separate send, persistence and replay delays while evaluating read guarantees and retained-WAL consequences.
IntermediateDatabases · Failures and antipatterns
Locate where estimated and observed row counts diverge, then test statistics, predicates and plan choices under the same inputs.
IntermediateDatabases · Failures and antipatterns
Understand finite XID ordering and freezing, then investigate age horizons and maintenance progress without disabling protections.
AdvancedDatabases · Experiments and implementations
Keep query semantics fixed while comparing composite-index order for equality, range filtering and ordering.
IntermediateDatabases · Experiments and implementations
Use an isolated PostgreSQL procedure to examine why covering columns alone do not eliminate visibility checks.
IntermediateDatabases · Experiments and implementations
Build ten thousand rows in an in-memory SQLite database, then compare access plans while checking that the query result stays the same.
IntroductoryDatabases · Experiments and implementations
Compare joins with narrow and broad predicates while distinguishing estimated rows, actual rows and repeated execution counts.
IntermediateDatabases · Experiments and implementations
Control updates across two sessions in one disposable local database to compare statement snapshots with transaction snapshots and their limits.
IntermediateDatabases · Experiments and implementations
Inspect whether a query implies a partial-index predicate, distinguishing fixed constants from a generic prepared plan.
IntermediateDatabases · Experiments and implementations
Inspect old row versions after updates while separating reusable space, relation size and approximate statistics.
IntermediateDatabases · Experiments and implementations
Schedule two on-call updates in separate sessions and distinguish same-row conflicts from write skew.
IntermediateDatabases · Study guides
Compare column order for recent-customer and open-order queries, then consider plans, storage, status updates and measurement scope.
IntermediateDatabases · Study guides
Connect index choices to filtering and ordering, distinguish planner estimates from measurements, and account for write costs.
IntermediateDatabases · Study guides
Separate updates, snapshots, dead tuples, and freezing to understand what VACUUM can reclaim and what it cannot.
IntermediateDatabases · Study guides
Connect statistics and selectivity to row estimates, then compare plans and actual execution without confusing per-loop counts or correlated predicates.
IntermediateDatabases · Study guides
Distinguish current and historical facts while deriving keys, losslessness,3NF/BCNF and dependency-preservation tradeoffs.
IntermediateDatabases · Study guides
Track how filtering, joining, and grouping change a result so that duplicates and NULL values do not silently change its meaning.
IntroductoryDatabases · Study guides
Compare three isolation levels using an on-call invariant, distinguishing snapshot stability, serialization rejection and whole-transaction retry.
IntermediateDatabases · Study guides
Separate atomicity from isolation, then use an inventory update to reason about rollback, conflicts, retries, and uncertain commit outcomes.
IntermediateDatabases · Study guides
Immediately stop and recover a dedicated cluster, distinguishing committed visibility, synchronization settings and backup restoration.
IntermediateDatabases · Design patterns and optimization
Design cache keys, generations and publication order so that a refresh cannot silently mix incompatible versions.
Intermediate