SEARCH LAVACS

Find a topic across LavaCS

Search textbooks, study guides, six encyclopedias, experiments and comparisons.

60 results · page 2 of 3

Databases · Failures and antipatterns

Database lock timeouts

Distinguish lock-acquisition deadlines from statement deadlines and connect blocker investigation with failed-transaction and retry handling.

Intermediate

Databases · Failures and antipatterns

The N+1 query problem

Find query amplification across a request and compare joins, batching and their data-shape tradeoffs.

Intermediate

Databases · Failures and antipatterns

Replication lag

Separate send, persistence and replay delays while evaluating read guarantees and retained-WAL consequences.

Intermediate

Databases · Failures and antipatterns

Transaction ID wraparound protection

Understand finite XID ordering and freezing, then investigate age horizons and maintenance progress without disabling protections.

Advanced

Databases · Experiments and implementations

Comparing join plans across selectivities

Compare joins with narrow and broad predicates while distinguishing estimated rows, actual rows and repeated execution counts.

Intermediate

Databases · Experiments and implementations

Observing MVCC snapshots across two sessions

Control updates across two sessions in one disposable local database to compare statement snapshots with transaction snapshots and their limits.

Intermediate

Databases · Design patterns and optimization

Cache versioning

Design cache keys, generations and publication order so that a refresh cannot silently mix incompatible versions.

Intermediate