pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <jim@nasby.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Horribly slow hash join
Date: Fri, 16 Apr 2004 11:46:44 -0500
Message-ID: <20040416164644.GH87362@nasby.net> (raw)
In-Reply-To: <450.1082133251@sss.pgh.pa.us>
References: <20040416154502.GF87362@nasby.net>
	<450.1082133251@sss.pgh.pa.us>

Yes, stats are up to date, and the values should be fairly unique.

Combined with the hash aggregate problem I saw (see my other email to
the list), do you think there could be some issue with the performance
of the hash function on FreeBSD 5.2 on AMD64?

I'll post the table you requested someplace you can grab it.

On Fri, Apr 16, 2004 at 12:34:11PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jim@nasby.net> writes:
> > Note the time for the hash join step:
> 
> Have you ANALYZEd these tables lately?
> 
> It looks to me like it's hashing on some column that has only a small
> number of distinct values, so that the hash doesn't actually help to
> avoid comparisons.  The planner should know better than to choose such
> a plan, but if it's working with obsolete stats ...
> 
> 			regards, tom lane
> 

-- 
Jim C. Nasby, Database Consultant                  jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



view thread (24+ messages)  latest in thread

Message-ID: <20040416164644.GH87362@nasby.net>
Permalink:  ../20040416164644.GH87362@nasby.net/
Also on:    postgresql.org/message-id/20040416164644.GH87362@nasby.net

 · 

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: jim@nasby.net, tgl@sss.pgh.pa.us
  Subject: Re: Horribly slow hash join
  In-Reply-To: <20040416164644.GH87362@nasby.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