SEARCH LAVACS

Find a topic across LavaCS

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

60 results · page 1 of 3

Databases · Comparisons and explanations

B-trees versus LSM trees

Compare B-tree and LSM storage designs through ordered access, buffering, compaction, tombstones and read/write/space amplification.

Intermediate

Databases · Comparisons and explanations

Hash indexes versus B-tree indexes

Compare PostgreSQL hash and B-tree indexes through equality, ranges, ordering, collisions and workload-dependent plan choices.

Intermediate

Databases · Comparisons and explanations

Logical versus physical replication

Compare PostgreSQL physical and logical replication by replication unit, selectable data, schema handling and migration or failover requirements.

Intermediate

Databases · Comparisons and explanations

MVCC versus two-phase locking

Compare version-based visibility with two-phase locking, including serialization guarantees, reader/writer interaction and implementation boundaries.

Intermediate

Databases · Comparisons and explanations

OLTP versus OLAP

Compare transactional and analytical workloads through access patterns, storage layout, indexes, concurrency and freshness requirements.

Intermediate

Databases · Comparisons and explanations

Read Committed versus Repeatable Read

Compare PostgreSQL isolation levels through snapshot timing, update conflicts and the anomalies that remain possible.

Intermediate

Databases · Comparisons and explanations

Serializability versus linearizability

Compare transaction serializability with operation linearizability using histories that distinguish atomic grouping from real-time order.

Intermediate

Databases · Comparisons and explanations

WAL versus snapshots

Compare a log of changes with a captured base state, and distinguish storage snapshots, backups and MVCC visibility snapshots during recovery planning.

Intermediate

Databases · Concepts and theorems

ACID: four distinct transaction properties

Use a transfer example to separate atomicity, consistency, isolation, and durability without treating the acronym as one unlimited guarantee.

Intermediate

Databases · Observation and diagnostics

Observing autovacuum progress and delays

Separate vacuum activity, phase progress and reclaimability while considering retained snapshots and transaction-ID protection.

Intermediate

Databases · Observation and diagnostics

Reading EXPLAIN ANALYZE

Separate estimates from measurements and interpret row counts, loops, and buffers when investigating PostgreSQL query plans.

Intermediate

Databases · Observation and diagnostics

Inspecting lock waits with pg_locks

Read lock targets, modes and granted state, then trace blocking with mode compatibility and queue dependencies in view.

Intermediate

Databases · Observation and diagnostics

Reading active work with pg_stat_activity

Separate connection, statement and transaction state and clocks, then use wait events and blockers to investigate current backend work.

Intermediate

Databases · Observation and diagnostics

Reading query trends with pg_stat_statements

Compare normalized SQL counts and execution-time deltas over a matched interval to distinguish accumulated workload cost from individual-request latency.

Intermediate

Databases · Observation and diagnostics

Reading PostgreSQL index-usage statistics

Interpret index counters with their windows and units, evaluating retrieval, writes, constraints and infrequent operational work.

Intermediate

Databases · Failures and antipatterns

Disk exhaustion and write failures

Identify mount, inode and quota constraints, preserve database recovery history, and verify both restored writes and recurrence causes.

Intermediate