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 A6F439DCD51 for ; Thu, 8 Dec 2005 12:33:18 -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 58223-03 for ; Thu, 8 Dec 2005 12:33:16 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.202]) by postgresql.org (Postfix) with ESMTP id 5AD789DCC94 for ; Thu, 8 Dec 2005 12:33:14 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i31so706745wra for ; Thu, 08 Dec 2005 08:33:14 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Mec7PQfKmtgN3TSVyNaTzJ+JfMSElxRXji+SDwYImtftgyy9f2yLp4GW32NiTGz4lu553nk7EDSAlGTJvZmysOJDXakjg8+ldvliLusQqSRLuhEBy7KrJ0ma37r28fl0zrCWKRnV0bEijFeoem7Qc/iRqGYUNXFYMFejSssh79o= Received: by 10.65.73.9 with SMTP id a9mr2871230qbl; Thu, 08 Dec 2005 08:33:14 -0800 (PST) Received: by 10.64.153.16 with HTTP; Thu, 8 Dec 2005 08:33:14 -0800 (PST) Message-ID: <731083980512080833q47791a2fr@mail.gmail.com> Date: Thu, 8 Dec 2005 14:33:14 -0200 From: Rodrigo Hjort To: pgsql-admin@postgresql.org Subject: REINDEX Issue - DB Management MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.772 required=5 tests=[AWL=0.772] X-Spam-Score: 0.772 X-Spam-Level: X-Archive-Number: 200512/69 X-Sequence-Number: 19789 - How often do you REINDEX your databases? - What do you verify on the database to know that it is time to reindex? I currently have a PostgreSQL 7.4.7 server with a 500 MB database (about 200 tables). I made a Shell script that calls /contrib/reindexdb. Then I put it on crontab, the way it is executed once a week and mails me the results after the operation. Do you think it is reasonable? -- Regards, Rodrigo Hjort GTI - Projeto PostgreSQL CELEPAR - Cia de Inform=E1tica do Paran=E1 http://www.pr.gov.br