Thanks for all the advice here. I'll look at setting up something in a test environment and play with the clustering.
Testinghow other queries perform against the clustering, also.
Thank you!
Sam
-----Original Message-----
From: David Kerr [mailto:dmk@mr-paradox.net]
Sent: Friday, 4 October 2013 1:55 AM
To: Samuel Stearns
Cc: Claudio Freire; David Johnston; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] 57 minute SELECT
On Thu, Oct 03, 2013 at 09:20:52AM -0700, David Kerr wrote:
- 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.
Sorry, ignore that, more coffe before mailing lists for me.