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