public inbox for [email protected]  

help / color / mirror / Atom feed

From: Joshua D. Drake <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: John Hansen <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Search out of sync
Date: Tue, 29 Aug 2006 11:45:16 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Bruce Momjian wrote:
> John Hansen wrote:
>> Index resync started, no new messages will be indexed until it's
>> finished.
>>
>> I missed the email about the archives was regenerated, and have spent
>> hours trying to work out what had happened.
>>
>> This problem would have resolved itself tho, as the archives are
>> reindexed every 30 days anyways.
> 
> It still does not work.  If you search "index bloat", the second item is
> "Constraints" and there is no mention of index bloat there.  Before the
> reindex, the second item said index bloat, but pointed to the
> "Constraints" email.  Could this be caused by Marc fixing the indexes
> based on pre-post July 2006 indexing needs.

Who knows :). I have no idea why the constraints email would show up at 
all frankly.

Sincerely,

Joshua D. Drake


> 
> --
>   Bruce Momjian   [email protected]
>   EnterpriseDB    http://www.enterprisedb.com
> 
>   + If your life is a hard drive, Christ can be your backup. +
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

view thread (17+ 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]
  Subject: Re: Search out of sync
  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