Help me please.
От | bdboy@samsung.co.kr |
---|---|
Тема | Help me please. |
Дата | |
Msg-id | 199804192346.IAA05383@omail30.unitel.co.kr обсуждение исходный текст |
Список | pgsql-hackers |
Hi I am sorry. I cant't English well. I want to know something. May I ask you a question? My system is a Linuxbox which is Redhat 5.0( Pentium 133MHz 80Mbyte Ram 120Mbyte Swap Memory) and Redhat 5.0)Pentium 160MHz 16Mbyte Ram 60Mbyte Swap Memory). I Install PostgrSQL 6.3.1. And I Install Int8 program, becuase data is greater then 5000000000(signed) I create table. like below create table lr( rec_cd char(2), actl_sect char(4), magam_ymd char(6), actl_hq char(2), actl_dept char(4), aip_cd char(1), cd char(2), bj char(2), val int8[][][], primary key(rec_cd,actl_sect,magam_ymd,aip_cd,cd,bj) ); Array val is [6][6][6] demension. Count(lr) is 33000 and. after time more then 1000000 record. I test query select lr.val[1][6][6] from lr where rec_cd='1' and actl_sect='9' and magam_ymd='199802' and aip_cd='1' and cd='MM' and bj='BT'; but result time is 30secend. Late!!! Why? I am bl ue.... Help me Please.
В списке pgsql-hackers по дате отправления: