ThinkerQAQ

2.PostgreSQL

Databases · 4 notes

  1. PostgreSQL Overviewhistorical

    PostgreSQL's relational engine, MVCC, WAL, extensibility, indexes, and operational model.

  2. PostgreSQL Isolation Levelshistorical

    Read Committed, Repeatable Read, Serializable, snapshots, and serialization failures.

  3. PostgreSQL MVCChistorical

    Tuple versions, transaction visibility, snapshots, dead tuples, and vacuum.

  4. PostgreSQL EXPLAINhistorical

    Reading scan, join, sort, aggregate, estimate, and runtime information from PostgreSQL plans.