Re: Search out of sync

From: "John Hansen" <john(at)geeknet(dot)com(dot)au>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: <aklaver(at)comcast(dot)net>, <pgsql-www(at)postgresql(dot)org>
Subject: Re: Search out of sync
Date: 2006-08-29 17:33:13
Message-ID: C88CF37B2468134A9A28F4B2BFDEBAB901A666@bdc.geeknet.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

Bruce Momjian Wrote:

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

No, the archives are being reindexed, and the indexer is still running.
While it's running, results will be somewhat screwed, until the reverse index is updated, which doesn't occur till it's been thru all of the pages. (some 500.000+ of them)

Be patient please.

Kind Regards,

John

In response to

Browse pgsql-www by date

  From Date Subject
Next Message Oleg Bartunov 2006-08-29 17:57:08 Re: A counter productive conversation about search.
Previous Message Bruce Momjian 2006-08-29 16:14:52 Re: PostgreSQL rebranding