X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E3BBAD1B534 for ; Wed, 12 Nov 2003 16:05:59 +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 10607-09 for ; Wed, 12 Nov 2003 12:05:28 -0400 (AST) Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by svr1.postgresql.org (Postfix) with ESMTP id 5875DD1B4EB for ; Wed, 12 Nov 2003 12:05:27 -0400 (AST) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.12.3/8.12.3/Debian-6.6) with SMTP id hACG5M5f015295; Wed, 12 Nov 2003 11:05:23 -0500 Reply-To: From: "Nick Fankhauser" To: "Manfred Koizar" , "Pgsql-Performance@Postgresql. Org" Subject: Re: Seeking help with a query that takes too long Date: Wed, 12 Nov 2003 11:05:10 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <03i4rv8cl6bgvr8r2c77ert3nfs0glfib8@email.aon.at> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/66 X-Sequence-Number: 4626 > >actor_full_name_uppercase on actor (cost=0.00..6.01 rows=1 width=42) > ^^^^^^ > >(actual time=37.62..677.44 rows=3501 loops=1) > ^^^^^^^^^ > Nick, can you find out why this row count estimation is so far off? ^^^^^^^^^ Oops- I read this backward- I see what you mean now. That's a good question. I'm not sure what part of the stats this estimate might be pulled from. The average is 357, but the most common frequency may be around 1. -Nick