X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 55AC85E3F15 for ; Fri, 13 Aug 2004 18:40:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92206-02 for ; Fri, 13 Aug 2004 21:40:12 +0000 (GMT) Received: from hotmail.com (bay17-dav19.bay17.hotmail.com [64.4.43.199]) by svr1.postgresql.org (Postfix) with ESMTP id C7D0C5E37D0 for ; Fri, 13 Aug 2004 18:40:10 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 13 Aug 2004 14:39:47 -0700 Received: from 142.104.250.115 by bay17-dav19.bay17.hotmail.com with DAV; Fri, 13 Aug 2004 21:39:46 +0000 X-Originating-IP: [142.104.250.115] X-Originating-Email: [borajetta@hotmail.com] X-Sender: borajetta@hotmail.com From: "borajetta" To: Subject: REINDEX needed because of index corruption need help ASAP Date: Fri, 13 Aug 2004 14:40:26 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0034_01C48143.7925F860" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: X-OriginalArrivalTime: 13 Aug 2004 21:39:47.0214 (UTC) FILETIME=[0DE43AE0:01C4817E] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/220 X-Sequence-Number: 7856 This is a multi-part message in MIME format. ------=_NextPart_000_0034_01C48143.7925F860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable select count(*) FROM items_2004_07_29 as items WHERE true AND index @@ to_t= squery('default', '( audiovox)') ; count=20 ------- 4 (1 row) aers=3D# reindex index idx_title_2004_07_29; REINDEX aers=3D# select count(*) FROM items_2004_07_29 as items WHERE true AND inde= x @@ to_tsquery('default', '( audiovox)') ; count=20 ------- 2342 (1 row) Here are 2 searches using a gist index, the first one has a gist index whic= h is not properly created but does not though an error in creation. After = doing a few searches I noticed the numbers were way off so I reindexed. Th= e problem was fixed and the search works properly. Is there a problem with indexing? Do you know of this problem? Is there a way to fix it? We are getting this error for other index's including primary key indexs wh= ere we get OID page not found errors and the index corruption as posted abo= ve. Sometimes when the index is broken it will cause run away searches which ea= t up all the memory and the server needs to be restarted. Anyways this all looks to be in index problem, vacuum/analyze does not fix = it only reindexing does. Thank you, Aaron ------=_NextPart_000_0034_01C48143.7925F860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
select count(*) FROM items_2004_07_29 as i= tems=20 WHERE true AND index @@ to_tsquery('default', '( audiovox)') ;
 cou= nt=20
-------
     4
(1 row)
 
aers=3D# reindex index=20 idx_title_2004_07_29;
REINDEX
aers=3D# select count(*) FROM items_200= 4_07_29=20 as items WHERE true AND index @@ to_tsquery('default', '( audiovox)')=20 ;
 count
-------
  2342
(1 row)
 
Here are 2 searches using a gist index, th= e first=20 one has a gist index which is not properly created but does not though an e= rror=20 in creation.  After doing a few searches I noticed the numbers were wa= y off=20 so I reindexed.  The problem was fixed and the search works=20 properly.
 
Is there a problem with indexing?  Do= you know=20 of this problem?
Is there a way to fix it?
 
We are getting this error for other index's including primary key inde= xs=20 where we get OID page not found errors and the index corruption as posted= =20 above.
Sometimes when the index is broken it will cause run away searches whi= ch=20 eat up all the memory and the server needs to be restarted.
 
Anyways this all looks to be in index problem, vacuum/analyze does not= fix=20 it only reindexing does.
 
Thank you,
 
Aaron
------=_NextPart_000_0034_01C48143.7925F860--