X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 300369DCC46 for ; Fri, 9 Dec 2005 00:18:15 -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 58534-06 for ; Fri, 9 Dec 2005 00:18:13 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 018429DCACB for ; Fri, 9 Dec 2005 00:18:13 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jB94IBDj073107 for ; Fri, 9 Dec 2005 04:18:11 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jB94HcTX072237 for pgsql-admin@postgresql.org; Fri, 9 Dec 2005 04:17:38 GMT (envelope-from news) From: "Qingqing Zhou" X-Newsgroups: pgsql.admin Subject: Re: REINDEX Issue - DB Management Date: Thu, 8 Dec 2005 23:18:34 -0500 Organization: Hub.Org Networking Services Lines: 16 Message-ID: References: <731083980512080833q47791a2fr@mail.gmail.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.44 required=5 tests=[ALL_TRUSTED=-1.44] X-Spam-Score: -1.44 X-Spam-Level: X-Archive-Number: 200512/75 X-Sequence-Number: 19795 "Rodrigo Hjort" wrote >- How often do you REINDEX your databases? > - What do you verify on the database to know that it is time to reindex? > There is no unique answer to the first one. You can binary search your optimal reindex rate. Suppose the workload is steady, then you first set reindex rate at, say, one time per week, then try twice per week, if it gets better, then try more frequent reindex. If not, then you can try 1 time per two-weeks and so on. Regards, Qingqing