Re: Search out of sync

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(at)momjian(dot)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/