"It’s significantly more efficient to do a count of a subquery’s results than to try to do a count with DISTINCT in a single query." – @peterbe about the best way to count distinct indexed things in #Postgres:http://ed.gr/blxmj
-
-
Thank you so much for the explanation. But my head is spinning on this. I need to digest that over time. So counting distinct values needs to be human-smart and depend on the nature of the indexed column.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.