X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5878F3A3FAF for ; Tue, 16 Nov 2004 10:56:10 +0000 (GMT) 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 69046-10 for ; Tue, 16 Nov 2004 10:56:04 +0000 (GMT) Received: from talisker.lacave.net (talisker.lacave.net [217.145.39.3]) by svr1.postgresql.org (Postfix) with SMTP id 601A53A3F95 for ; Tue, 16 Nov 2004 10:56:03 +0000 (GMT) Received: (qmail 43082 invoked from network); 16 Nov 2004 10:55:41 -0000 Received: from localhost (HELO ballantines.local) (127.0.0.1) by talisker.lacave.net with SMTP; 16 Nov 2004 10:55:41 -0000 Date: Tue, 16 Nov 2004 11:55:59 +0100 From: "F. Senault" X-Mailer: The Bat! (v3.0.1.33) Professional Reply-To: "F. Senault" Organization: Secte de l'Elephant Fuschia X-Priority: 3 (Normal) Message-ID: <179155563.20041116115559@lacave.net> To: pgsql-performance@postgresql.org Subject: Re: mis-estimation on data-warehouse aggregate creation In-Reply-To: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanner: F-prot v4.4.7 (engine 3.14.13) X-Virus-Definitions: SIGN.DEF (11 November 2004), SIGN2.DEF (12 November 2004), MACRO.DEF (15 November 2004) X-Virus-Flag: NO X-Remote-IP: 127.0.0.1 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: 200411/220 X-Sequence-Number: 9174 Tuesday, November 16, 2004, 10:10:17 AM, you wrote: > HashAggregate (cost=32869.33..32869.34 rows=1 width=36) ^ > (actual time=475182.855..475188.304 rows=911 loops=1) ^^^ > -> Nested Loop (cost=377.07..32869.32 rows=1 width=36) ^ > (actual time=130.179..464299.167 rows=1232140 loops=1) ^^^^^^^ Let me guess... You've never run "analyze" on your tables ? Fred