| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org>, "Kevin Grittner" <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov> |
| Subject: | Re: OUTER JOIN performance regression remains in 8.3beta4 |
| Date: | 2008-01-04 22:16:53 |
| Message-ID: | 477E5BF4.EE98.0025.0@wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
>>> On Fri, Jan 4, 2008 at 12:16 PM, in message
<477E238D(dot)EE98(dot)0025(dot)0(at)wicourts(dot)gov>, "Kevin Grittner"
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> problems remain in 8.3beta4.
As I poked around at this, it started to seem familiar. I had
previously posted about this query's performance under 8.2.4.
http://archives.postgresql.org/pgsql-performance/2007-10/msg00087.php
To summarize, under 8.2.4 it runs in less than half a millisecond
if I set enable_hashjoin = off and thousand times that long with
enable_hashjoin = on. Under 8.3beta4 this has jumped to 113114 ms.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-04 22:29:32 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
| Previous Message | Brett Schwarz | 2008-01-04 22:07:15 | Re: Problem with PgTcl auditing function on trigger |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-04 22:29:32 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
| Previous Message | Andrew Sullivan | 2008-01-04 20:08:07 | Re: SSL over Unix-domain sockets |