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-hornYou might also want to read
Hello,
I just discovered the explain command and well ... have some (for you
of course very stupid) questions.
I do a quite large (for my taste) join, the query looks like the following:
SELECT DISTINCT customer.email AS cemail, customer.key AS ckey,
customer.anrede AS canrede, customer.strasse
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Clemens Eisserer
Sent: Wednesday, May 10, 2006 6:50 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Question about explain-command...
What does the hash-lines mean, does that mean my
I will try answering your questions. Please note that I am a newbie myself.
Clemens Eisserer wrote
All primary keys are indixed, and this is what explain tells me:
Unique (cost=15.67..16.69 rows=34 width=115)
- Sort (cost=15.67..15.75 rows=34 width=115)
Sort Key: customer.email,