X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 30721563A2 for ; Mon, 14 Mar 2005 07:39:43 +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 13054-02 for ; Mon, 14 Mar 2005 07:39:42 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D595456386 for ; Mon, 14 Mar 2005 07:39:41 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2E7dfQM006179; Mon, 14 Mar 2005 02:39:41 -0500 (EST) To: Gourish Singbal Cc: pgsql-admin@postgresql.org Subject: Re: Need Help with reindexing In-reply-to: <674d1f8a050313221149c690bb@mail.gmail.com> References: <674d1f8a050313221149c690bb@mail.gmail.com> Comments: In-reply-to Gourish Singbal message dated "Mon, 14 Mar 2005 11:41:39 +0530" Date: Mon, 14 Mar 2005 02:39:41 -0500 Message-ID: <6178.1110785981@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/204 X-Sequence-Number: 16702 Gourish Singbal writes: > I need some help to decide when i should reindex the indexes in the table. > ... > When should i ideally reindex this table ?. > (once in a month, weekly....etc) It seems to need reindexing now, but that tells us nothing about how often you might need to do it. My advice is that you probably need to vacuum more often, rather than deciding you need periodic reindexes. regards, tom lane