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.
boringsql.com on Hacker News
9 stories on the front page, newest first. Scroll down to watch the site change over time.
The DISTINCT in Your COUNT(boringsql.com)
17 points by gmcabrita | 2 comments
Vacuum at the Page Level(boringsql.com)
18 points by radimm | 5 comments
Good CTE, Bad CTE(boringsql.com)
149 points by radimm | 34 comments
Instant database clones with PostgreSQL 18(boringsql.com)
386 points by radimm | 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.
