Help me please.

From: bdboy(at)samsung(dot)co(dot)kr
To: pgsql-hackers(at)postgresql(dot)org
Subject: Help me please.
Date: 1998-04-20 08:37:31
Message-ID: 199804192346.IAA05383@omail30.unitel.co.kr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-04-20 10:08:45 errors on transactions and locks ?
Previous Message Tom Lane 1998-04-19 23:57:45 Re: [HACKERS] Proposal for async support in libpq