| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz> |
| Cc: | John Arbash Meinel <john(at)arbash-meinel(dot)com>, PGSQL mailing list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: How to read query plan |
| Date: | 2005-03-13 20:26:27 |
| Message-ID: | 3174.1110745587@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
=?windows-1250?Q?Miroslav_=8Aulc?= <miroslav(dot)sulc(at)startnet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2005-03-13 21:26:13 | Re: Cost of XLogInsert CRC calculations |
| Previous Message | Miroslav Šulc | 2005-03-13 20:03:34 | Re: How to read query plan |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-14 00:08:41 | Re: [PERFORM] How to read query plan |
| Previous Message | Miroslav Šulc | 2005-03-13 20:03:34 | Re: How to read query plan |