From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: No hash join across partitioned tables? |
Date: | 2009-04-17 17:05:32 |
Message-ID: | 49E8B6DC.5040508@ejurka.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Tom Lane wrote:
> Kris Jurka <books(at)ejurka(dot)com> writes:
>> The hash join takes less than twenty seconds, the other two joins I
>> killed after five minutes. I can try to collect explain analyze results
>> later today if you'd like.
>
Attached are the explain analyze results. The analyze part hits the
hash join worst of all, so I've also included the timings without analyzing.
Method Time (ms) Time w/Analyze (ms)
nestloop 304853 319060
merge 514517 683757
hash 18957 143731
Kris Jurka
Attachment | Content-Type | Size |
---|---|---|
hash.txt | text/plain | 3.1 KB |
merge.txt | text/plain | 3.8 KB |
nestloop.txt | text/plain | 4.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2009-04-17 17:06:32 | Re: Replacing plpgsql's lexer |
Previous Message | Martijn van Oosterhout | 2009-04-17 17:01:47 | Re: [rfc] unicode escapes for extended strings |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Wakeling | 2009-04-17 17:18:45 | Re: GiST index performance |
Previous Message | Tom Lane | 2009-04-17 15:08:24 | Re: No hash join across partitioned tables? |