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

• OUTER JOIN performance regression remains in 8.3beta4 at 2008-01-04 18:16:13 from Kevin Grittner

Responses

• Re: OUTER JOIN performance regression remains in 8.3beta4 at 2008-01-04 22:40:22 from Tom Lane

pgsql-hackers by date

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

pgsql-patches by date

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