Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 253DA2E00AA for ; Tue, 29 Jan 2008 14:17:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 29363-01-8 for ; Tue, 29 Jan 2008 14:17:19 -0400 (AST) Received: from main1.mycybernet.net (main1.mycybernet.net [209.222.63.135]) by postgresql.org (Postfix) with ESMTP id 69C522E2E89 for ; Tue, 29 Jan 2008 14:09:32 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main1.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JJutn-0008Nu-Hr for pgsql-performance@postgresql.org; Tue, 29 Jan 2008 13:09:31 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 9787550021; Tue, 29 Jan 2008 13:09:26 -0500 (EST) Date: Tue, 29 Jan 2008 13:09:26 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: analyze Message-ID: <20080129180926.GG26594@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <479F381D.4000809@careerjunction.co.za> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <479F381D.4000809@careerjunction.co.za> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/297 X-Sequence-Number: 28536 On Tue, Jan 29, 2008 at 04:28:45PM +0200, Adrian Moisey wrote: > > Seriously though, how do I try measure this? Is autovacuum not going to work for your case? A