Re: 57 minute SELECT

From: Samuel Stearns <sstearns(at)staff(dot)iinet(dot)net(dot)au>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: Claudio Freire <klaussfreire(at)gmail(dot)com>, David Johnston <polobo(at)yahoo(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 57 minute SELECT
Date: 2013-10-03 22:49:20
Message-ID: CB03CD8D2C3F9347BAFEC8EA9DD89C9318D392D9@ISP-OSB-DAG2.win2k.iinet.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thanks for all the advice here. I'll look at setting up something in a test environment and play with the clustering. Testing how other queries perform against the clustering, also.

Thank you!

Sam

-----Original Message-----
From: David Kerr [mailto:dmk(at)mr-paradox(dot)net]
Sent: Friday, 4 October 2013 1:55 AM
To: Samuel Stearns
Cc: Claudio Freire; David Johnston; pgsql-performance(at)postgresql(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Stearns 2013-10-03 23:05:19 Re: 57 minute SELECT
Previous Message David Kerr 2013-10-03 16:25:00 Re: 57 minute SELECT