From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200803121809.m2CI9RQ13220@momjian.us>
Subject: Re: Email not searchable in our archives
In-Reply-To: <937d27e10803121022n3a138f43ted07ced62790549f@mail.gmail.com>
To: Dave Page <dpage@pgadmin.org>
Date: Wed, 12 Mar 2008 14:09:27 -0400 (EDT)
CC: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>,
	Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@commandprompt.com>,
	PostgreSQL www <pgsql-www@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

Dave Page wrote:
> On Wed, Mar 12, 2008 at 5:16 PM, Bruce Momjian <bruce@momjian.us> 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 :-(

31k emails.  Wow.

Thanks, I just checked an email that use to be missing and it is there
now.  Thanks!

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +