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.

RegreSQL: Regression Testing for PostgreSQL Queries(boringsql.com)

130 points by radimm 11 months ago | 31 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.

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

22 points by masklinn 2 months ago | 9 comments

Telegram Serverless(core.telegram.org)

159 points by soheilpro 3 months ago | 90 comments

Good CTE, Bad CTE(boringsql.com)

149 points by radimm 7 months ago | 34 comments