X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C5A419FB1DA for ; Fri, 7 Jul 2006 19:49:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 77341-07 for ; Fri, 7 Jul 2006 19:49:35 -0300 (ADT) X-Greylist: delayed 00:20:21.541028 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A5A3A9FB215 for ; Fri, 7 Jul 2006 19:49:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.brownpapertickets.com (mail.brownpapertickets.com [66.235.70.236]) by svr4.postgresql.org (Postfix) with ESMTP id BA74E5AF07B for ; Fri, 7 Jul 2006 22:29:08 +0000 (GMT) Received: from flashheart.brownpapertickets.com (dsl254-061-182.sea1.dsl.speakeasy.net [216.254.61.182]) by mail.brownpapertickets.com (8.13.6/8.12.8) with ESMTP id k67MNs60006517 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Fri, 7 Jul 2006 15:23:55 -0700 Message-Id: <6.2.3.0.2.20060707145857.0342ca58@mail.pandimensional.com> X-Mailer: QUALCOMM Windows Eudora Version 6.2.3.0 Date: Fri, 07 Jul 2006 15:29:19 -0700 To: pgsql-performance@postgresql.org From: William Scott Jordan Subject: VACUUM vs. REINDEX Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/73 X-Sequence-Number: 19933 Hi all! Can anyone explain to me what VACUUM does that REINDEX doesn't? We have a frequently updated table on Postgres 7.4 on FC3 with about 35000 rows which we VACUUM hourly and VACUUM FULL once per day. It seem like the table still slows to a crawl every few weeks. Running a REINDEX by itself or a VACUUM FULL by itself doesn't seem to help, but running a REINDEX followed immediately by a VACUUM FULL seems to solve the problem. I'm trying to decide now if we need to include a daily REINDEX along with our daily VACUUM FULL, and more importantly I'm just curious to know why we should or shouldn't do that. Any information on this subject would be appreciated. -Scott