Re: Email not searchable in our archives

Dave Page wrote:
> On Wed, Mar 12, 2008 at 4:55 PM, Stefan Kaltenbrunner
> <stefan@kaltenbrunner.cc> wrote:
> >
> > Tom Lane wrote:
> >  > "Dave Page" <dpage@pgadmin.org> writes:
> >  >> On Wed, Mar 12, 2008 at 3:41 PM, Tom Lane <tgl@sss.pgh.pa.us> 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 ;-)
> 
> 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.

--  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. +