Mehdi Akiki

Posts tagged "postgresql"

  • Published on

    Article · Interrupted execution

    Retry the Whole PostgreSQL Transaction from Rust

    Force a serialization conflict with two SQLx connections and check that a bounded retry opens a new transaction and repeats the reads that chose the write.
  • Published on

    Investigation · Part 15 of 20 · What survives a crash

    Durability Settings That Trade Your Data for Speed

    SQLite synchronous, PostgreSQL synchronous_commit, MySQL innodb_flush_log_at_trx_commit, Redis appendfsync: each one decides how much a crash may lose. I put them in one table, with a column for each kind of crash. Only SQLite is measured here; the others are their documentation.