public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Dave Page <[email protected]>
Cc: Stefan Kaltenbrunner <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: PostgreSQL www <[email protected]>
Subject: Re: Email not searchable in our archives
Date: Wed, 12 Mar 2008 13:16:23 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

Dave Page wrote:
> On Wed, Mar 12, 2008 at 4:55 PM, Stefan Kaltenbrunner
> <[email protected]> wrote:
> >
> > Tom Lane wrote:
> >  > "Dave Page" <[email protected]> writes:
> >  >> On Wed, Mar 12, 2008 at 3:41 PM, Tom Lane <[email protected]> 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  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

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

view thread (51+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Email not searchable in our archives
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox