X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 11E9FD1B37E for ; Fri, 16 Jul 2004 23:28:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47505-08 for ; Sat, 17 Jul 2004 02:28:25 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id D06F4D1B195 for ; Fri, 16 Jul 2004 23:28:20 -0300 (ADT) Received: from [134.22.68.4] (dyn-68-4.tor.dsl.tht.net [134.22.68.4]) by tht.net (Postfix) with ESMTP id 7693876A6D; Fri, 16 Jul 2004 22:28:30 -0400 (EDT) Subject: Re: Query plan discrepancies From: Rod Taylor To: Bob Arens Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain Message-Id: <1090031298.81714.8.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Fri, 16 Jul 2004 22:28:18 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/108 X-Sequence-Number: 18360 Have you run ANALYZE recently? Please send back EXPLAIN ANALYZE for the below query. > EXPLAIN from DB 2 (doesn't come back): > QUERY PLAN > ------------------------------------------------------------------------------------------------------------------------- > HashAggregate (cost=7763.55..7763.56 rows=1 width=8) > -> Nested Loop (cost=4363.86..7763.55 rows=1 width=8) > -> HashAggregate (cost=4363.86..4363.86 rows=200 width=146) > -> Seq Scan on word_stats_base (cost=0.00..4126.09 > rows=95109 width=146) > -> Index Scan using medline_abstract_tokens_norm on > medline_abstract_tokens (cost=0.00..16.99 rows=1 width=8) > Index Cond: ((medline_abstract_tokens.norm)::text = > ("outer".norm_token)::text) > Filter: (pmid = 7968456) > (7 rows)