Radim Marek: How TABLESAMPLE picks rows

boringSQL | Supercharge your SQL & PostgreSQL powers

Radim Marek: How TABLESAMPLE picks rows

TABLESAMPLE picks addresses, not rows: SYSTEM samples come in bundles, BERNOULLI with REPEATABLE drifts after an UPDATE, and a hashed key gives you the same rows tomorrow.

TABLESAMPLE picks addresses, not rows: SYSTEM samples come in bundles, BERNOULLI with REPEATABLE drifts after an UPDATE, and a hashed key gives you the same rows tomorrow.