Re: 57 minute SELECT - Mailing list pgsql-performance

From David Kerr
Subject Re: 57 minute SELECT
Date
Msg-id 20131003162049.GA5072@mr-paradox.net
Whole thread Raw
In response to Re: 57 minute SELECT  (Samuel Stearns <sstearns@staff.iinet.net.au>)
Responses Re: 57 minute SELECT  (David Kerr <dmk@mr-paradox.net>)
List pgsql-performance
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.



pgsql-performance by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: 57 minute SELECT
Next
From: David Kerr
Date:
Subject: Re: 57 minute SELECT