X-Original-To: pgsql-www-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BA65F9FB253 for ; Tue, 29 Aug 2006 12:55:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 35799-04 for ; Tue, 29 Aug 2006 12:55:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id B79DA9FB218 for ; Tue, 29 Aug 2006 12:55:36 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id k7TFtXo01576; Tue, 29 Aug 2006 11:55:33 -0400 (EDT) From: Bruce Momjian Message-Id: <200608291555.k7TFtXo01576@momjian.us> Subject: Re: Search out of sync In-Reply-To: To: John Hansen Date: Tue, 29 Aug 2006 11:55:33 -0400 (EDT) CC: aklaver@comcast.net, pgsql-www@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.125 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/171 X-Sequence-Number: 10562 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. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +