X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DA418D8B43 for ; Wed, 28 Sep 2005 00:33:42 -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 46632-05 for ; Wed, 28 Sep 2005 03:33:41 +0000 (GMT) Received: from mail.nordicbet.com (mail.nordicbet.com [193.69.167.130]) by svr1.postgresql.org (Postfix) with ESMTP id CC212D85EC for ; Wed, 28 Sep 2005 00:33:40 -0300 (ADT) Received: from [80.203.125.83] (helo=tobias.nordicbet.invalid) (Authenticated Sender=tobias@nordicbet.com) by mail.nordicbet.com with esmtpa (Exim 4.50 #1 (Debian)) id 1EKSdw-00079A-TO for ; Wed, 28 Sep 2005 05:30:14 +0200 Received: by tobias.nordicbet.invalid (Postfix, from userid 500) id 531F0504C; Wed, 28 Sep 2005 05:33:28 +0200 (CEST) Date: Wed, 28 Sep 2005 05:33:27 +0200 From: Tobias Brox To: pgsql-performance@postgresql.org Subject: The need for full vacuum / reindex Message-ID: <20050928033327.GU5679@tobias.lan> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Organization: Group Nordicbet User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/385 X-Sequence-Number: 14693 By occation, we dropped the whole production database and refreshed it from a database backup - and all our performance problems seems to have gone. I suppose this means that to keep the database efficient, one eventually does have to do reindexing and/or full vacuum from time to time? -- Notice of Confidentiality: This email is sent unencrypted over the network, and may be stored on several email servers; it can be read by third parties as easy as a postcard. Do not rely on email for confidential information.