Postgres Pro
Downloads
Home   >   mailing lists

Re: How to read query plan - Mailing list pgsql-performance

From Tom Lane
Subject Re: How to read query plan
Date
Msg-id 3174.1110745587@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
List pgsql-performance
Tree view 
=?windows-1250?Q?Miroslav_=8Aulc?= <miroslav.sulc@startnet.cz> writes:
> There are only JOINs number against number.

Hmph.  There's no reason I can see that hash joins should be as slow as
they seem to be in your test.

Is the data confidential?  If you'd be willing to send me a pg_dump
off-list, I'd like to replicate this test and try to see where the time
is going.

            regards, tom lane

pgsql-performance by date:

Previous
From: Miroslav Šulc
Date:
Subject: Re: How to read query plan
Next
From: Tom Lane
Date:
Subject: Re: How to read query plan