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 D160653437 for ; Tue, 12 Apr 2005 15:14:54 -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 89997-02 for ; Tue, 12 Apr 2005 18:14:43 +0000 (GMT) Received: from mail.99main.com (mail.99main.com [208.28.184.11]) by svr1.postgresql.org (Postfix) with ESMTP id 72939533C4 for ; Tue, 12 Apr 2005 15:14:37 -0300 (ADT) Received: from 99main.com (localhost [127.0.0.1]) by mail.99main.com (8.12.8+Sun/8.12.8) with ESMTP id j3CIEQQL018074; Tue, 12 Apr 2005 14:14:26 -0400 (EDT) From: "Keith Worthington" To: "Dave Held" , "PostgreSQL Perform" Reply-To: KeithW@narrowpathinc.com Subject: Re: 4 way JOIN using aliases Date: Tue, 12 Apr 2005 14:14:26 -0400 Message-Id: <20050412181234.M15392@narrowpathinc.com> In-Reply-To: <49E94D0CFCD4DB43AFBA928DDD20C8F9026184A9@asg002.asg.local> References: <49E94D0CFCD4DB43AFBA928DDD20C8F9026184A9@asg002.asg.local> X-Mailer: Open WebMail 2.50 20050106 X-OriginatingIP: 68.235.22.242 (npkeithw) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/241 X-Sequence-Number: 11638 On Tue, 12 Apr 2005 08:41:55 -0500, Dave Held wrote > > -----Original Message----- > > From: Keith Worthington [mailto:KeithW@narrowpathinc.com] > > Sent: Monday, April 11, 2005 7:44 PM > > To: Neil Conway > > Cc: PostgreSQL Perform > > Subject: Re: [PERFORM] 4 way JOIN using aliases > > > > 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? > > > [...] > > > > 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. > > Pass it an --analyze option if you aren't already. > > __ > David B. Held > Here is the command I have in the cron file. vacuumdb --full --analyze --verbose --username dbuser --dbname ${IPA_DB} >> ${IPA_LOG_DIR}/ipavcmdb.log 2>&1 If this performs the analyze as I thought it should I do not know why the row count is so badly off. Kind Regards, Keith