X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6695311F68CA for ; Fri, 31 Mar 2006 12:02:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44679-06 for ; Fri, 31 Mar 2006 12:02:21 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id 8541111F68CF for ; Fri, 31 Mar 2006 12:02:20 -0400 (AST) Received: by nproxy.gmail.com with SMTP id l24so577717nfc for ; Fri, 31 Mar 2006 08:02:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:date:from:to:subject:message-id:x-mailer:mime-version:content-type:content-transfer-encoding; b=ZG3wHxFDqVQu7d75DS17O4x3fesguxRBU3XrlfpUiR6vslsqvUzTjva8MAFZcxeO0O9duw8WHEblSsqgUPMs/3uTIRt1uO0gdBNsX/fVnco3bcGWt5h2skYBCmdbwtyIcUm8NYd0v4/rRPnUcEJ6hIzcsE1fs9TuqJbv7L1Vpzk= Received: by 10.48.254.11 with SMTP id b11mr404747nfi; Fri, 31 Mar 2006 08:02:18 -0800 (PST) Received: from localhost.localdomain ( [129.217.191.31]) by mx.gmail.com with ESMTP id c10sm78433nfb.2006.03.31.08.02.18; Fri, 31 Mar 2006 08:02:18 -0800 (PST) Date: Fri, 31 Mar 2006 18:02:16 +0200 From: Frederic Back To: pgsql-performance@postgresql.org Subject: un-'vacuum analyse' Message-Id: <20060331180216.f25c3e91.fredericback@gmail.com> X-Mailer: Sylpheed version 2.1.1 (GTK+ 2.8.16; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.332 required=5 tests=[RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.332 X-Spam-Level: * X-Archive-Number: 200603/641 X-Sequence-Number: 18078 Hello, I would like to know how my application works before and after data from VACUUM ANALYSE is available. Is there a way to de-'vacuum analyse' a database for testing purposes? Thank you, Fred