Re: 57 minute SELECT

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Samuel Stearns <sstearns(at)staff(dot)iinet(dot)net(dot)au>
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 16:20:52
Message-ID: 20131003162049.GA5072@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Kerr 2013-10-03 16:25:00 Re: 57 minute SELECT
Previous Message ktm@rice.edu 2013-10-03 12:59:18 Re: 57 minute SELECT