Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5BE572E2EB9 for ; Wed, 12 Mar 2008 11:15:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19784-02 for ; Wed, 12 Mar 2008 11:14:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 1B2F22E2D4C for ; Wed, 12 Mar 2008 11:15:01 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so224464ugf.49 for ; Wed, 12 Mar 2008 07:14:59 -0700 (PDT) Received: by 10.150.195.21 with SMTP id s21mr4572480ybf.87.1205331298488; Wed, 12 Mar 2008 07:14:58 -0700 (PDT) Received: by 10.150.96.5 with HTTP; Wed, 12 Mar 2008 07:14:58 -0700 (PDT) Message-ID: <937d27e10803120714h21f1f661s657fad641f35c3d5@mail.gmail.com> Date: Wed, 12 Mar 2008 14:14:58 +0000 From: "Dave Page" To: "Alvaro Herrera" Subject: Re: Email not searchable in our archives Cc: "Bruce Momjian" , "PostgreSQL www" In-Reply-To: <20080312130902.GC4926@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200803112135.m2BLZ6625071@momjian.us> <20080312130902.GC4926@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/253 X-Sequence-Number: 14372 On Wed, Mar 12, 2008 at 1:09 PM, Alvaro Herrera wrote: > I'm looking at the problem. On a quick glance it is obvious that > there's something bogus going on -- the search database only contains > 472 emails for May 2007, but Mhonarc reports 1187. Confirmed. I added a test mode to a copy of the archives indexer, and running that it claims it would index a further 715 messages, which would give us a total of 1187. So I guess the next step is to try running out of test mode to see if the data actually makes it into the index now, but I didn't want to do that and stomp on any testing you're doing. -- Dave Page EnterpriseDB UK Ltd: http://www.enterprisedb.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk