>>> On Fri, Jan 4, 2008 at 12:16 PM, in message
<[EMAIL PROTECTED]>, "Kevin Grittner"
<[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
