4 ms·
"We are migrating our analytics db from Mongo to PG but we hit a wall because SELECT COUNT(DISTINCT x)) performs abysmally in Postgres." https://github.com/agg
by ris 10y ago
"We are migrating our analytics db from Mongo to PG but we hit a wall because SELECT COUNT(DISTINCT x)) performs abysmally in Postgres."
https://github.com/aggregateknowledge/postgresql-hll https://github.com/aggregateknowledge/postgresql-hll ?
or even
https://www.periscopedata.com/blog/hyperloglog-in-pure-sql.html https://www.periscopedata.com/blog/hyperloglog-in-pure-sql.h... ?