On Thu, Oct 03, 2013 at 01:47:29AM +0000, Samuel Stearns wrote:
- Thanks, Claudio:
-
- http://explain.depesz.com/s/WJQx
You're spending a lot of time in the hash join which can kill a system with
low ram.
You may, just for fun, want to try the query with enable_hashjoin=false.