X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 84DDD329E79; Sun, 12 Sep 2004 06:09:32 +0100 (BST) 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 37066-02; Sun, 12 Sep 2004 05:09:23 +0000 (GMT) Received: from rodrick.geeknet.com.au (ns1.geeknet.com.au [220.244.63.182]) by svr1.postgresql.org (Postfix) with ESMTP id C1F42329CA4; Sun, 12 Sep 2004 06:09:22 +0100 (BST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Search on www and archives X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Date: Sun, 12 Sep 2004 15:09:18 +1000 Message-ID: <5066E5A966339E42AA04BA10BA706AE5619D@rodrick.geeknet.com.au> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Search on www and archives Thread-Index: AcSXPE6kVe23AkxZSW2vpaWekSQQegBSRvcg From: "John Hansen" To: "Marc G. Fournier" , 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: 200409/83 X-Sequence-Number: 5153 Guys, As it turned out, my worst fears came true last night. The machine which is hosting the search, had bad memory, and crashed while crawling one of the incremental runs on archives. This in turn caused filesystem corruption on the reverse index, which has made the database more or less useless. I've reindexed all of the websites except for archives, which will take about a week to complete at the current speed. Until it has finished, searching the archives is likely to return odd results, and searching on www.search will not include the archives. A backup strategy was not in place due to reorganisation of the hardware/vm's, tho it will be over the next few weeks. ... John