X-Original-To: pgsql-www-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E6EEC9FB1FB for ; Tue, 29 Aug 2006 04:21:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 72317-03 for ; Tue, 29 Aug 2006 07:21:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bdc.geeknet.com.au (gateway.geeknet.com.au [210.8.38.58]) by postgresql.org (Postfix) with ESMTP id ED7599FB1F9 for ; Tue, 29 Aug 2006 04:21:50 -0300 (ADT) Subject: Re: Search out of sync Date: Tue, 29 Aug 2006 17:21:46 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-ID: In-Reply-To: <200608290010.k7T0A4d01908@momjian.us> Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.5 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [pgsql-www] Search out of sync Thread-Index: AcbK/4dmzq+W40z1T12pXqiuEFySLQAO5DQQ From: "John Hansen" To: "Bruce Momjian" , Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/153 X-Sequence-Number: 10544 Index resync started, no new messages will be indexed until it's = finished.=20 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. Kind regards, John > -----Original Message----- > From: pgsql-www-owner@postgresql.org=20 > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Bruce Momjian > Sent: Tuesday, August 29, 2006 10:10 AM > To: aklaver@comcast.net > Cc: pgsql-www@postgresql.org > Subject: Re: [pgsql-www] Search out of sync >=20 > Adrian Klaver wrote: > > I am seeing the same behavior as reported in the message below. > > http://archives.postgresql.org/pgsql-www/2006-08/msg00105.php > >=20 > > Is there a fix in the works? >=20 > I just tested "index bloat" and I can confirm that the second=20 > returned result is incorrect if you click on it. Is anyone=20 > addressing this? >=20 > --=20 > Bruce Momjian bruce@momjian.us > EnterpriseDB http://www.enterprisedb.com >=20 > + If your life is a hard drive, Christ can be your backup. + >=20 > ---------------------------(end of=20 > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? >=20 > http://www.postgresql.org/docs/faq >=20