X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id AC499310850 for ; Mon, 30 Jun 2003 14:27:06 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 92690-10 for ; Mon, 30 Jun 2003 11:26:56 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id BDD5A31083E for ; Mon, 30 Jun 2003 11:26:55 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5UEQtQQ004537; Mon, 30 Jun 2003 10:26:55 -0400 (EDT) To: "Anagha Joshi" Cc: pgsql-sql@postgresql.org Subject: Re: Seqno. is not btree? In-reply-to: References: Comments: In-reply-to "Anagha Joshi" message dated "Mon, 30 Jun 2003 16:23:50 +0530" Date: Mon, 30 Jun 2003 10:26:55 -0400 Message-ID: <4536.1056983215@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/338 X-Sequence-Number: 14096 "Anagha Joshi" writes: > After as many as 2412081 records are inserted, I shutdown my server. > Next day,I tried the following: > test=3D# select count(*) from vchar; > count > ------- > 2568 > (1 row) > test=3D# insert into vchar (col_var) values ('VV'); > ERROR: Index vchar_seqno_key is not a btree It sounds to me like you've got serious disk problems --- losing a couple hundred thousand rows is not normal :-(. The index complaint also suggests on-disk corruption --- it means that the btree version information that's stored in the first page of a btree index wasn't right. How exactly did you "shut down the server"? Have you noticed any other evidence of disk problems, outside Postgres? regards, tom lane