Message-ID: <44F48B3C.1090108@commandprompt.com>
Date: Tue, 29 Aug 2006 11:45:16 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.5 (X11/20060728)
MIME-Version: 1.0
To: Bruce Momjian <bruce@momjian.us>
CC: John Hansen <john@geeknet.com.au>, aklaver@comcast.net,
	pgsql-www@postgresql.org
Subject: Re: Search out of sync
References: <200608291555.k7TFtXo01576@momjian.us>
In-Reply-To: <200608291555.k7TFtXo01576@momjian.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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   bruce@momjian.us
>   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/