Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 04DAF2E02ED for ; Wed, 12 Mar 2008 13:56:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69611-03 for ; Wed, 12 Mar 2008 13:55:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 7CFBA2E0307 for ; Wed, 12 Mar 2008 13:55:39 -0300 (ADT) Received: from congw.dc1.conova.com ([217.196.145.250] helo=[192.168.1.61]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1JZUEf-0002wS-Pp; Wed, 12 Mar 2008 17:55:31 +0100 Message-ID: <47D80B19.7000906@kaltenbrunner.cc> Date: Wed, 12 Mar 2008 17:55:53 +0100 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.14pre (X11/20080208) MIME-Version: 1.0 To: Tom Lane CC: Dave Page , Alvaro Herrera , Bruce Momjian , PostgreSQL www Subject: Re: Email not searchable in our archives References: <200803112135.m2BLZ6625071@momjian.us> <20080312130902.GC4926@alvh.no-ip.org> <937d27e10803120714h21f1f661s657fad641f35c3d5@mail.gmail.com> <937d27e10803120825k67fc19c1h27f977a8038dfdd7@mail.gmail.com> <19584.1205336481@sss.pgh.pa.us> <937d27e10803120904g3198fd51vd4a51a36e556eca7@mail.gmail.com> <20051.1205338017@sss.pgh.pa.us> In-Reply-To: <20051.1205338017@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/263 X-Sequence-Number: 14382 Tom Lane wrote: > "Dave Page" writes: >> On Wed, Mar 12, 2008 at 3:41 PM, Tom Lane wrote: >>> That would explain a contiguous range of messages that were not indexed, >>> but is that what we have? > >> Looking at the debug output, the messages that were missed were all contiguous: > > OK, that seems to support your theory. Might as well go ahead and > reindex. +1 for getting some monitoring in there somewhere. yeah we will work on that and add some new ones to our current list of 354 active checks ;-) Stefan