X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6D0953A3CB7 for ; Tue, 2 Nov 2004 20:23:26 +0000 (GMT) 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 81741-05 for ; Tue, 2 Nov 2004 20:23:23 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 3B8903A3C7C for ; Tue, 2 Nov 2004 20:23:24 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id iA2KNMJ7082693 for ; Tue, 2 Nov 2004 20:23:22 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id iA2JwjxJ074839 for pgsql-docs@postgresql.org; Tue, 2 Nov 2004 19:58:45 GMT From: stig erikson X-Newsgroups: comp.databases.postgresql.docs Subject: 7.4.6 docs, chapter 21.2 Date: Tue, 02 Nov 2004 20:58:13 +0100 Organization: Hub.Org Networking Services Lines: 15 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8a5) Gecko/20041028 X-Accept-Language: en-us, en, sv, nn, nb, no, pl To: pgsql-docs@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/14 X-Sequence-Number: 2649 7.4.6 docs, chapter 21.2 Routine Reindexing has a very limited amount of information. it would be good to know how much of this is taken care of VACUUM and under what circumstances it is needed to do reindex. it would also be good to add some information on how to disable/enable autoamtic reindex on insert/update/delete if such automatic reindexing exists. if it is available somewhere else, please write a note on where to find more info. in chapeter 21.1 i could as well be an idea writing a line or two about what (if any) vacuum does to indecies.