Vacuum at the Page Level(boringsql.com)

18 points by radimm 3 months ago | 5 comments

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

22 points by masklinn 2 months ago | 9 comments

Vacuum Is a Lie: About Your Indexes(boringsql.com)

74 points by birdculture 10 months ago | 41 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.

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.

Good CTE, Bad CTE(boringsql.com)

149 points by radimm 7 months ago | 34 comments