X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 9FE509FB1A5
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 11 May 2006 19:41:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 99694-07
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu, 11 May 2006 19:41:14 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from noel.decibel.org (noel.decibel.org [67.100.216.10])
	by postgresql.org (Postfix) with ESMTP id 3B9559FADD1
	for <pgsql-performance@postgresql.org>;
	Thu, 11 May 2006 19:41:14 -0300 (ADT)
Received: by noel.decibel.org (Postfix, from userid 1001)
	id F16EA56435; Thu, 11 May 2006 17:41:12 -0500 (CDT)
Received: (hashcash-sendmail, from uid 1001); Thu, 11 May 2006 17:41:12 -0500
Date: Thu, 11 May 2006 17:41:12 -0500
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Dave Dutcher <dave@tridecap.com>
Cc: 'Clemens Eisserer' <linuxhippy@gmail.com>,
 pgsql-performance@postgresql.org
Subject: Re: Question about explain-command...
Message-ID: <20060511224111.GX99570@pervasive.com>
References: <194f62550605100449p2d200fc3pfe501da895cfcc00@mail.gmail.com>
	<01a901c67440$9cf097e0$8300a8c0@tridecap.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <01a901c67440$9cf097e0$8300a8c0@tridecap.com>
X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.11
X-Hashcash: 
 1:20:060511:dave@tridecap.com::gHNSdTHJz/4Gb3Dc:00000000000000000000
	0000000000000000000000001fp3
X-Hashcash: 
 1:20:060511:linuxhippy@gmail.com::llzGLtMuap2hyn9P:00000000000000000
	0000000000000000000000003/WS
X-Hashcash: 
 1:20:060511:pgsql-performance@postgresql.org::LLB5TIS3qzdMq3nq:00000
	0000000000000000000000002ASW
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/309
X-Sequence-Number: 19096

On Wed, May 10, 2006 at 09:47:07AM -0500, Dave Dutcher wrote:
> The hash lines mean your tables are being joined by hash joins.  You
> should read this page for more info:
> 
> http://www.postgresql.org/docs/8.1/interactive/performance-tips.html

<tooting-own-horn>You might also want to read
http://www.pervasivepostgres.com/instantkb13/article.aspx?id=10120&query=explain
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461