PostgreSQL's MVCC is bad. So is everyone else's(boringsql.com)

22 points by masklinn 2 months ago | 9 comments

Tablesample Picks Rows(boringsql.com)

3 points by surprisetalk 4 days ago | 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.

Vacuum at the Page Level(boringsql.com)

18 points by radimm 3 months ago | 5 comments

PostgREST Tutorial: APIs made easy(notso.boringsql.com)

20 points by radimm 2 years ago | 4 comments

Instant database clones with PostgreSQL 18(boringsql.com)

386 points by radimm 10 months ago | 148 comments

A boringSQL blog post by Radim Marek explaining how to create instant database clones in PostgreSQL 18 for testing, migrations, and reproducible snapshots.

SQLite transactions and virtual tables(misfra.me)

90 points by preetamjinka 1 year ago | 9 comments