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.
#query-performance on Hacker News
4 stories tagged query-performance, newest first.
Shredding JSON columns gave Logfire up to 1000x faster queries(pydantic.dev)
19 points by acossta | 14 comments
Pydantic blog post explaining how dynamically shredding JSON columns into typed columns gave Logfire up to 1000x faster queries.
Why DuckDB 2.0 is faster(motherduck.com)
192 points by tosh | 60 comments
MotherDuck blog post by Mehdi Ouazza testing DuckDB 2.0 alpha features like async I/O over S3 and recursive CTEs, explaining why the new version is faster.
Postgres SELECT DISTINCT Does Not Scale(dbos.dev)
83 points by KraftyOne | 26 comments
A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.