Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 02E7C2E02D2 for ; Tue, 29 Jan 2008 10:29:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 94098-04 for ; Tue, 29 Jan 2008 10:28:56 -0400 (AST) Received: from cptwks26.careerjunction.local (unknown [196.212.105.173]) by postgresql.org (Postfix) with ESMTP id EAD122E008E for ; Tue, 29 Jan 2008 10:28:54 -0400 (AST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by cptwks26.careerjunction.local (Postfix) with ESMTP id 06BC3B7A4F for ; Tue, 29 Jan 2008 16:28:45 +0200 (SAST) Message-ID: <479F381D.4000809@careerjunction.co.za> Date: Tue, 29 Jan 2008 16:28:45 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: analyze Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/285 X-Sequence-Number: 28524 Hi How long is a piece of string? While we're at it, how often do I vacuum analyze? Seriously though, how do I try measure this? -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842