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 5E78A5344F for ; Mon, 11 Apr 2005 21:41:19 -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 31075-07 for ; Tue, 12 Apr 2005 00:41:10 +0000 (GMT) Received: from mxsf32.cluster1.charter.net (mxsf32.cluster1.charter.net [209.225.28.156]) by svr1.postgresql.org (Postfix) with ESMTP id 7382B5344E for ; Mon, 11 Apr 2005 21:41:09 -0300 (ADT) Received: from mxip11.cluster1.charter.net (mxip11a.cluster1.charter.net [209.225.28.141]) by mxsf32.cluster1.charter.net (8.12.11/8.12.11) with ESMTP id j3C0fB8b006563 for ; Mon, 11 Apr 2005 20:41:11 -0400 Received: from pc-68-118-180-13.will.ct.charter.com (HELO [192.168.116.102]) (68.118.180.13) by mxip11.cluster1.charter.net with ESMTP; 11 Apr 2005 20:41:03 -0400 X-Ironport-AV: i="3.92,95,1112587200"; d="scan'208"; a="1022360654:sNHT566498826" Message-ID: <425B19C2.1050703@NarrowPathInc.com> Date: Mon, 11 Apr 2005 20:43:46 -0400 From: Keith Worthington Reply-To: KeithW@NarrowPathInc.com Organization: Narrow Path, Inc. User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Neil Conway Cc: PostgreSQL Perform Subject: Re: 4 way JOIN using aliases References: <20050407140133.M89867@narrowpathinc.com> <4259D8FA.9060307@samurai.com> In-Reply-To: <4259D8FA.9060307@samurai.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.105 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/221 X-Sequence-Number: 11618 Neil Conway wrote: > Keith Worthington wrote: > >> -> Seq Scan on tbl_current (cost=0.00..1775.57 rows=76457 >> width=31) (actual time=22.870..25.024 rows=605 loops=1) > > > This rowcount is way off -- have you run ANALYZE recently? > > -Neil > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > Neil, I run vacuumdb with the analyze option every morning via a cron job. In my ignorance I do not know if that is the same thing. -- Kind Regards, Keith