Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 94ADB2E3251 for ; Wed, 12 Mar 2008 14:23:43 -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 75549-02-9 for ; Wed, 12 Mar 2008 14:23:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.190]) by postgresql.org (Postfix) with ESMTP id 966272E0264 for ; Wed, 12 Mar 2008 14:22:43 -0300 (ADT) Received: by gv-out-0910.google.com with SMTP id y18so858849gvf.7 for ; Wed, 12 Mar 2008 10:22:42 -0700 (PDT) Received: by 10.150.185.14 with SMTP id i14mr4669396ybf.157.1205342560849; Wed, 12 Mar 2008 10:22:40 -0700 (PDT) Received: by 10.150.96.5 with HTTP; Wed, 12 Mar 2008 10:22:40 -0700 (PDT) Message-ID: <937d27e10803121022n3a138f43ted07ced62790549f@mail.gmail.com> Date: Wed, 12 Mar 2008 17:22:40 +0000 From: "Dave Page" To: "Bruce Momjian" Subject: Re: Email not searchable in our archives Cc: "Stefan Kaltenbrunner" , "Tom Lane" , "Alvaro Herrera" , "PostgreSQL www" In-Reply-To: <200803121716.m2CHGNx09453@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <937d27e10803120956hbbd915enac074784f0b2ea3@mail.gmail.com> <200803121716.m2CHGNx09453@momjian.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/269 X-Sequence-Number: 14388 On Wed, Mar 12, 2008 at 5:16 PM, Bruce Momjian wrote: > Dave Page wrote: > > One thing that crosses my mind - perhaps we should run a full index > > once per week to try to catch this sort of thing in the future? > > Seems running it weekly would mean failures would disappear and not be > diagnosed. There is that - but then at least the index should be up to date within 7 days at all times regardless of any corner cases that we might otherwise not notice for some time. BTW, the reindexing just finished - it added 31,269 messages that were previously missing :-( -- Dave Page EnterpriseDB UK Ltd: http://www.enterprisedb.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk