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.



Mon, 20 Apr 1998 08:37:31 KST
bdboy@samsung.co.kr
Help me please.