X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8141A475C3D for ; Fri, 28 Mar 2003 16:03:33 -0500 (EST) Received: from geek.artcobell.com (unknown [63.114.209.181]) by postgresql.org (Postfix) with SMTP id 1748C475458 for ; Fri, 28 Mar 2003 16:03:30 -0500 (EST) Received: (qmail 18609 invoked from network); 28 Mar 2003 20:58:58 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost.uu.net with SMTP; 28 Mar 2003 20:58:58 -0000 From: Jeremiah Elliott Reply-To: jelliott@artcobell.com Organization: Artco-Bell Corp. To: pgsql-performance@postgresql.org Subject: Re: slow query - where not in Date: Fri, 28 Mar 2003 14:58:48 -0600 User-Agent: KMail/1.5 References: <200303280938.50382.jelliott@artcobell.com> <028e01c2f54a$9af3d010$3201a8c0@beeblebrox> <20030328175356.GA12549@wolff.to> In-Reply-To: <20030328175356.GA12549@wolff.to> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200303281458.48326.jelliott@artcobell.com> X-Spam-Status: No, hits=-12.8 required=5.0 tests=BAYES_20,IN_REP_TO,REFERENCES,USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/187 X-Sequence-Number: 1485 thanks guys - Greg, Bruno and Michael. That made a world of diferance. thx -Jeremiah