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?"
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