Skip site navigation (1) Skip section navigation (2)

Re: OUTER JOIN performance regression remains in8.3beta4

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 in8.3beta4
Date: 2008-01-04 22:16:53
Message-ID: 477E5BF4.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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
 



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-01-04 22:29:32
Subject: Re: OUTER JOIN performance regression remains in 8.3beta4
Previous:From: Brett SchwarzDate: 2008-01-04 22:07:15
Subject: Re: Problem with PgTcl auditing function on trigger

pgsql-patches by date

Next:From: Tom LaneDate: 2008-01-04 22:29:32
Subject: Re: OUTER JOIN performance regression remains in 8.3beta4
Previous:From: Andrew SullivanDate: 2008-01-04 20:08:07
Subject: Re: SSL over Unix-domain sockets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group