X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3B53DD1B982 for ; Wed, 20 Aug 2003 03:57: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 45053-06 for ; Wed, 20 Aug 2003 03:57:01 -0300 (ADT) Received: from PELL33 (pell33.alleg.edu [141.195.45.33]) by svr1.postgresql.org (Postfix) with ESMTP id 22430D1D1ED for ; Wed, 20 Aug 2003 03:57:00 -0300 (ADT) From: To: Subject: Re: Wicked screensaver Date: Wed, 20 Aug 2003 2:57:34 --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: <20030820065700.22430D1D1ED@svr1.postgresql.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/223 X-Sequence-Number: 14839 Please see the attached file for details. From pgsql-sql-owner@postgresql.org Wed Aug 20 10:11:07 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 51365D1B8F1 for ; 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 ; 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 ; 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 ; Wed, 20 Aug 2003 10:10:40 -0300 (ADT) From: To: 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.C4CB1CF4A17@www.postgresql.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@postgresql.org Wed Aug 20 11:03:49 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BA695D1CE47 for ; 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 ; 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 ; 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 ; Wed, 20 Aug 2003 14:03:06 +0000 (GMT) From: To: 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.14C911CB4734@svr4.postgresql.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@postgresql.org Wed Aug 20 13:19:29 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2F18CD1B8E0 for ; 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 ; 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 ; 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@127.0.0.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 X-X-Sender: To: Subject: "SELECT IN" Still Broken in 7.4b Message-ID: 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 FROM WHERE IN () 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.winter@frontlogic.com