postgresql COUNT(DISTINCT …) very slow

by

You can use this:

SELECT COUNT(*) FROM (SELECT DISTINCT column_name FROM table_name) AS temp;

This is much faster than:

COUNT(DISTINCT column_name)

More Related Contents:

  1. LOWER LIKE vs iLIKE
  2. MongoDB ‘count()’ is very slow. How do we refine/work around with it?
  3. How to efficiently count the number of keys/properties of an object in JavaScript
  4. Speed up the loop operation in R
  5. One could use a profiler, but why not just halt the program? [closed]
  6. Spark functions vs UDF performance?
  7. Adding a redundant assignment speeds up code when compiled without optimization
  8. Why is this SSE code 6 times slower without VZEROUPPER on Skylake?
  9. How many Include I can use on ObjectSet in EntityFramework to retain performance?
  10. Faster way to find the first empty row in a Google Sheet column
  11. 32-byte aligned routine does not fit the uops cache
  12. Why is SSE scalar sqrt(x) slower than rsqrt(x) * x?
  13. Haskell foldl’ poor performance with (++)
  14. Which Intel microarchitecture introduced the ADC reg,0 single-uop special case?
  15. Storing Documents as Blobs in a Database – Any disadvantages?
  16. Can modern x86 implementations store-forward from more than one prior store?
  17. Cellfun versus Simple Matlab Loop performance
  18. timing code in matlab
  19. Minimizing overhead due to the large number of Numpy dot calls
  20. What are the rules for the “Ω(n log n) barrier” for sorting algorithms?
  21. Getting total row count from OFFSET / FETCH NEXT
  22. Content-Length header versus chunked encoding
  23. How to find pair with kth largest sum?
  24. Git is really slow for 100,000 objects. Any fixes?
  25. Does Scala support tail recursion optimization?
  26. Memory Allocation/Deallocation Bottleneck?
  27. Move all odd positioned element to left half and even positioned to right half in-place
  28. preallocate list in R
  29. How to analyze golang memory?
  30. How to avoid Query Plan re-compilation when using IEnumerable.Contains in Entity Framework LINQ queries?

Leave a Comment