Select random rows from PostgreSQL - Cacher Snippet

7/28/2019 - 2:02 PM

Select random rows from PostgreSQL

从postgres数据库中返回若干条随机记录，用于初始阶段简单的数据探查。

Tablesample In PostgreSQL

SELECT select_expression
FROM table_name
TABLESAMPLE SYSTEM/BERNOULLI ( argument [, ...] )
-- SYSTEM sampling method does block/page level sampling; BERNOULLI sampling method does a sequential scan.