Re: Wicked screensaver

Please see the attached file for details.
>From pgsql-sql-owner(at)postgresql(dot)org Wed Aug 20 10:11:07 2003
X-Original-To: pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id 51365D1B8F1
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 20 Aug 2003 10:10:52 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 45094-03
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 20 Aug 2003 10:10:44 -0300 (ADT)
Received: from www.postgresql.com (www.postgresql.com [64.117.225.209])
by svr1.postgresql.org (Postfix) with ESMTP id 6B2DFD1BB06
for <pgsql-sql(at)postgresql(dot)org>; Wed, 20 Aug 2003 10:10:41 -0300 (ADT)
Received: from BAH-506330-HO (FAIRVIEWPARK-190-169.usae.bah.com [156.80.190.169])
by www.postgresql.com (Postfix) with ESMTP id C4CB1CF4A17
for <pgsql-sql(at)postgresql(dot)org>; Wed, 20 Aug 2003 10:10:40 -0300 (ADT)
From: <alessio(at)albourne(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Wicked screensaver
Date: Wed, 20 Aug 2003 9:06:33 --0400
X-MailScanner: Found to be clean
Importance: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MSMail-Priority: Normal
X-Priority: 3 (Normal)
MIME-Version: 1.0
Message-Id: <20030820131040(dot)C4CB1CF4A17(at)www(dot)postgresql(dot)com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=4.5 tagged_above=0.0 required=5.0
tests=DATE_IN_PAST_03_06, FORGED_MUA_OUTLOOK, INVALID_DATE,
MIME_BOUND_NEXTPART, MISSING_MIMEOLE, NO_REAL_NAME
X-Spam-Level: ****
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset="iso-8859-1"
X-Archive-Number: 200308/224
X-Sequence-Number: 14840

See the attached file for details
>From pgsql-sql-owner(at)postgresql(dot)org Wed Aug 20 11:03:49 2003
X-Original-To: pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id BA695D1CE47
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 20 Aug 2003 11:03:13 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 59566-05
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 20 Aug 2003 11:03:06 -0300 (ADT)
Received: from svr4.postgresql.org (svr4.postgresql.org [64.117.224.192])
by svr1.postgresql.org (Postfix) with ESMTP id 6BCE9D1B9B2
for <pgsql-sql(at)postgresql(dot)org>; Wed, 20 Aug 2003 11:03:02 -0300 (ADT)
Received: from BAH-506330-HO (FAIRVIEWPARK-190-169.usae.bah.com [156.80.190.169])
by svr4.postgresql.org (Postfix) with ESMTP id 14C911CB4734
for <pgsql-sql(at)postgresql(dot)org>; Wed, 20 Aug 2003 14:03:06 +0000 (GMT)
From: <zakkr(at)zf(dot)jcu(dot)cz>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Approved
Date: Wed, 20 Aug 2003 9:58:55 --0400
X-MailScanner: Found to be clean
Importance: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MSMail-Priority: Normal
X-Priority: 3 (Normal)
MIME-Version: 1.0
Message-Id: <20030820140306(dot)14C911CB4734(at)svr4(dot)postgresql(dot)org>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=4.5 tagged_above=0.0 required=5.0
tests=DATE_IN_PAST_03_06, FORGED_MUA_OUTLOOK, INVALID_DATE,
MIME_BOUND_NEXTPART, MISSING_MIMEOLE, NO_REAL_NAME
X-Spam-Level: ****
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset="iso-8859-1"
X-Archive-Number: 200308/225
X-Sequence-Number: 14841

Please see the attached file for details.
>From pgsql-sql-owner(at)postgresql(dot)org Wed Aug 20 13:19:29 2003
X-Original-To: pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
by svr1.postgresql.org (Postfix) with ESMTP id 2F18CD1B8E0
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 20 Aug 2003 13:19:29 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
with ESMTP id 07895-03
for <pgsql-sql-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 20 Aug 2003 13:19:19 -0300 (ADT)
Received: from frontlogic.com (gw.frontlogic.com [207.195.92.149])
by svr1.postgresql.org (Postfix) with SMTP id 298DCD1BA9F
for <pgsql-sql(at)postgresql(dot)org>; Wed, 20 Aug 2003 13:19:16 -0300 (ADT)
Received: (qmail 849 invoked by uid 614); 20 Aug 2003 16:32:45 -0000
Received: from localhost (sendmail-bs(at)127(dot)0(dot)0(dot)1)
by localhost with SMTP; 20 Aug 2003 16:32:45 -0000
Date: Wed, 20 Aug 2003 10:32:45 -0600 (CST)
From: Mike Winter <mike(dot)winter(at)frontlogic(dot)com>
X-X-Sender: <mike(dot)w(at)frontlogic(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: "SELECT IN" Still Broken in 7.4b
Message-ID: <Pine(dot)LNX(dot)4(dot)33L2(dot)0308201002210(dot)6023-100000(at)frontlogic(dot)com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/226
X-Sequence-Number: 14842

I'm sure many on this list are sick of hearing about this problem, but it
was on the fix list for 7.4, but doesn't appear to have been changed.

You can see one of the many threads on the problem at:
http://archives.postgresql.org/pgsql-sql/2003-05/msg00352.php

Basically, queries of the form SELECT <rows> FROM <table> WHERE <row> IN
(<list of values>) take forever for high numbers of rows in the IN clause.
We've done timing on 7.3 and 7.4b and there is no speed improvement on
these queries.

Does anyone know what the status of this bug is?
--
_______________________________________________________________________
Front Logic Inc. Tel: 306.653.2725 x14
226 Pacific Ave or 1.800.521.4510 x14
Saskatoon, SK Fax: 306.653.0972
S7K 1N9 Canada Cell: 306.717.2550
http://www.frontlogic.com mike(dot)winter(at)frontlogic(dot)com