Seqno. is not btree?

Поиск
Список
Период
Сортировка
От Anagha Joshi
Тема Seqno. is not btree?
Дата
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com
обсуждение исходный текст
Ответы Re: Seqno. is not btree?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
<p align="LEFT"><span lang="en-us"><font face="Arial" size="2">Hi,</font></span><p align="LEFT"><span
lang="en-us"><fontface="Arial" size="2">I use Postgresql-7.2.4</font></span><span lang="en-us"></span><span
lang="en-us"></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">I’ve created following
table:</font></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">create table vchar (</font></span><p
align="LEFT"><spanlang="en-us"><font face="Arial" size="2">    seqno SERIAL,</font></span><p align="LEFT"><span
lang="en-us"><fontface="Arial" size="2">    col_var character varying (8192)</font></span><p align="LEFT"><span
lang="en-us"><fontface="Arial" size="2">    );</font></span><span lang="en-us"></span><span lang="en-us"></span><p
align="LEFT"><spanlang="en-us"><font face="Arial" size="2">After as many as</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Arial" size="2">2412081</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2"> records are inserted,  I shutdown my server.</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Arial" size="2"> My every record was inserted programatically by
:</font></span><palign="LEFT"><span lang="en-us"><b><font face="Arial" size="2">insert into vchar (col_var) values
(‘VVV’)</font></b></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">……</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">(</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2">VVV’ char sequence was 8192 times long. i.e. in one row 8192</font></span><span
lang="en-us"><b></b></span><spanlang="en-us"><b> <font face="Arial" size="2">V’s</font></b></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2"> are present.</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">)</font></span><span lang="en-us"></span><span
lang="en-us"></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">Next day,</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">I tried the following:</font></span><p
align="LEFT"><spanlang="en-us"><font face="Arial" size="2">test=# select count(*) from vchar;</font></span><p
align="LEFT"><spanlang="en-us"><font face="Arial" size="2"> count</font></span><p align="LEFT"><span lang="en-us"><font
face="Arial"size="2">-------</font></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2"> 
2568</font></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">(1 row)</font></span><span
lang="en-us"></span><spanlang="en-us"></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">test=#
insertinto vchar (col_var) values ('</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial"
size="2">VV’);</font></span><spanlang="en-us"></span><span lang="en-us"></span><p align="LEFT"><span
lang="en-us"><b><fontface="Arial" size="2">ERROR:  Index vchar_seqno_key is not a btree</font></b></span><span
lang="en-us"><b></b></span><spanlang="en-us"><b></b></span><p align="LEFT"><span lang="en-us"><font face="Arial"
size="2">Whatdoes this error mean? My server log shows</font></span><span lang="en-us"></span><span lang="en-us"> <font
face="Arial"size="2">2412081</font></span><span lang="en-us"></span><span lang="en-us"><font face="Arial" size="2">
recordsinserted but actual</font></span><span lang="en-us"><b></b></span><span lang="en-us"><b> <font face="Arial"
size="2">count(*)</font></b></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2"> shows only
2568</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2"> records.</font></span><span
lang="en-us"></span><spanlang="en-us"></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">Pls.
help.</font></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">Thx.,</font></span><p
align="LEFT"><spanlang="en-us"><font face="Arial" size="2">Anagha</font></span><span lang="en-us"></span><span
lang="en-us"></span><br/> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Abdul Wahab Dahalan
Дата:
Сообщение: select column from table
Следующее
От: "Rudi Starcevic"
Дата:
Сообщение: Bitwise operation