feeding my datasheet search engine database its favourite treat, a whole CPU core
Follow
well crap, it knocked over the container and now I've lost three whole CPU cores...
Where on earth is this remaining sort operation coming from??
Aha, forgot that UNION also does a uniqueness check. Changing it to UNION ALL fixed that.
@joepie91 it’s hungry!!
@kim I already gave it so many cores though :( I was having load averages of 40+!
So apparently removing the DISTINCT cuts the query time in half, but it's still very slow...
With DISTINCT: https://explain.depesz.com/s/cOeV
Without DISTINCT: https://explain.depesz.com/s/QAIM5