November 2014

I noticed the server load was high. I saw that several instances of search by date where still running. Looking at the query in question: The analysis for this query is available at http://explain.depesz.com/s/uCT I redesigned the query to make use of explicit JOINs: The analysis for that query is at http://explain.depesz.com/s/p3wn. I’ll let readers […]