Periscope Data Blog company blog

Use SQL subqueries to count distinct 50x faster

by Sisense Team periscope.io published 2023-04-14

NB: These techniques are universal, but for syntax we chose Postgres. Thanks to the inimitable pgAdminIII for the Explain graphics. So useful, yet so slow

Points

289

HN comments

98

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2014

Related posts from the same era

Visualizing Algorithms

MMike Bostock20141,557 points129 commentscited by 38 details

Command-line tools can be faster than your Hadoop cluster

Adam Drake2015812 points480 commentscited by 23 details

Goodbye MongoDB, Hello PostgreSQL

OOlery Developer Blog2015802 points545 comments details

PostgreSQL 9.4 Released

PostgreSQL2014744 points188 comments details

Don't use Hadoop when your data isn't that big

Chris Stucchio2013711 points611 commentscited by 15 details

ASCII Delimited Text – Not CSV or TAB delimited text

Ronald Duncan2014695 points397 commentscited by 8 details