Tablesample Picks Rows(boringsql.com)
3 points by surprisetalk | 0 comments
A technical blog post explaining how PostgreSQL's TABLESAMPLE SYSTEM and BERNOULLI methods select rows by hashing physical addresses, and the resulting sampling biases.
#mvcc on Hacker News
2 stories tagged mvcc, newest first.
MVCC – the part of PostgreSQL we hate the most (2023)(cs.cmu.edu)
341 points by virtualwhys | 109 comments
Andy Pavlo blog post from April 2023 criticizing PostgreSQL's multi-version concurrency control (MVCC) implementation and its drawbacks.