X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E7EDCD1B541 for ; Mon, 3 Nov 2003 19:49:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26618-04 for ; Mon, 3 Nov 2003 15:49:04 -0400 (AST) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 34B6AD1CAA3 for ; Mon, 3 Nov 2003 15:49:02 -0400 (AST) Received: (qmail 16584 invoked by uid 65534); 3 Nov 2003 19:49:02 -0000 Received: from dsl-082-082-167-160.arcor-ip.net (EHLO dsl-082-082-167-160.arcor-ip.net) (82.82.167.160) by mail.gmx.net (mp004) with SMTP; 03 Nov 2003 20:49:02 +0100 X-Authenticated: #495269 Date: Mon, 3 Nov 2003 20:49:02 +0100 (CET) From: Peter Eisentraut X-X-Sender: peter@peter.localdomain To: pgsql-docs@postgresql.org Subject: Section "Routine Reindexing" Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/4 X-Sequence-Number: 2081 The section "Routine Reindexing" (21.2) has been reduced to: """ In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command. (There is also contrib/reindexdb which can reindex an entire database.) However, PostgreSQL 7.4 has substantially reduced the need for this activity compared to earlier releases. """ Can someone add something that is of substantial value and less hand-wavy? -- Peter Eisentraut peter_e@gmx.net