Snowflake(@Snowflake):Need “about 497K unique users” faster than an exact COUNT(DISTINCT)? Postgres gives you a few options: TABLESAMPLE, HyperLogLog and mergeable sketches. The trick is knowing when each approximation works and where it breaks. Dive into this walkthrough: https://t.co/DXaFwZy3AV

Snowflake

@Snowflake

The AI Data Cloud where data does more, and proud to be the Official Data Collaboration Provider for LA28 and Team USA.

参加 June 2014

1.2K フォロー中 64.5K ファン

Snowflake@Snowflake

2026.08.06 23:00

Need “about 497K unique users” faster than an exact COUNT(DISTINCT)? Postgres gives you a few options: TABLESAMPLE, HyperLogLog and mergeable sketches. The trick is knowing when each approximation works and where it breaks. Dive into this walkthrough: