pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: David Kerr <dmk@mr-paradox.net>
To: Samuel Stearns <sstearns@staff.iinet.net.au>
Cc: Claudio Freire <klaussfreire@gmail.com>
Cc: David Johnston <polobo@yahoo.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: 57 minute SELECT
Date: Thu, 3 Oct 2013 09:25:00 -0700
Message-ID: <20131003162500.GA5763@mr-paradox.net> (raw)
In-Reply-To: <20131003162049.GA5072@mr-paradox.net>
References: <CB03CD8D2C3F9347BAFEC8EA9DD89C9318D3785F@ISP-OSB-DAG2.win2k.iinet.net.au>
	<1380763034169-5773174.post@n5.nabble.com>
	<CB03CD8D2C3F9347BAFEC8EA9DD89C9318D379A1@ISP-OSB-DAG2.win2k.iinet.net.au>
	<CAGTBQpbMrJCTTicpGwfRRaHQ5haitdeqA9hCSpBiTFALYZVoMg@mail.gmail.com>
	<CB03CD8D2C3F9347BAFEC8EA9DD89C9318D37A50@ISP-OSB-DAG2.win2k.iinet.net.au>
	<20131003162049.GA5072@mr-paradox.net>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

view thread (18+ messages)  latest in thread

Message-ID: <20131003162500.GA5763@mr-paradox.net>
Permalink:  ../20131003162500.GA5763@mr-paradox.net/
Also on:    postgresql.org/message-id/20131003162500.GA5763@mr-paradox.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dmk@mr-paradox.net, sstearns@staff.iinet.net.au, klaussfreire@gmail.com, polobo@yahoo.com
  Subject: Re: 57 minute SELECT
  In-Reply-To: <20131003162500.GA5763@mr-paradox.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox