X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E2833D1BC54 for ; Mon, 1 Dec 2003 16:25:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 33340-04 for ; Mon, 1 Dec 2003 12:25:10 -0400 (AST) Received: from mailhost3.tudelft.nl (mailhost3.tudelft.nl [130.161.180.14]) by svr1.postgresql.org (Postfix) with ESMTP id 8DC79D1B4AA for ; Mon, 1 Dec 2003 12:25:09 -0400 (AST) Received: from 127.0.0.1 (localhost [127.0.0.1]) by rav.antivirus (Postfix) with SMTP id 19872263E; Mon, 1 Dec 2003 17:25:08 +0100 (MET) Received: from listserv.tudelft.nl (witlab.tudelft.nl [130.161.180.33]) by mailhost3.tudelft.nl (Postfix) with ESMTP id 0190927D5; Mon, 1 Dec 2003 17:25:08 +0100 (MET) Received: from acm (x193056-2.shuis-s.tudelft.nl [145.94.193.58]) by listserv.tudelft.nl (8.12.10/8.12.8) with ESMTP id hB1GOwQQ025391; Mon, 1 Dec 2003 17:25:07 +0100 (MET) From: "Arjen van der Meijden" To: "'Jeremiah Jahn'" , "'Hannu Krosing'" Cc: "'postgres performance'" Subject: Re: cross table indexes or something? Date: Mon, 1 Dec 2003 17:24:43 +0100 Message-ID: <002901c3b827$a48aeff0$3ac15e91@acm> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <1070288942.22346.27.camel@bluejay.goodinassociates.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_30, FORGED_RCVD_TRAIL, IN_REP_TO, QUOTED_EMAIL_TEXT X-Spam-Level: X-Archive-Number: 200312/12 X-Sequence-Number: 4872 > Jeremiah Jahn wrote: > > > Have you run ANALYZE ? Why does DB think that there is only > one judge > > with name like SMITH% ? > I've attached the Analyze below. I have no idea why the db > thinks there is only 1 judge named simth. Is there some what > I can inform the DB about this. In actuality, there aren't > any judges named smith at the moment, but there are 22K > people named smith. > I think you're mistaking the command EXPLAIN ANALYZE for the command ANALYZE. Have you actually run the command ANALYZE or perhaps even better if you haven't vacuumed before: VACUUM FULL ANALYZE If you have no idea what vacuum is, check the manual. If you've already run such a VACUUM/ANALYZE-command, then ignore this message :) Best regards, Arjen van der Meijden