I have a tabel I am trying to use but it won't work. Here are the
particulars:
Digital Unix 4.0E
Postgres 6.3
DEC 3000 400s
100M+ memory
500M swap
8 gig drive reserved for postgres
To create the table:
#!/bin/sh
psql sis << \__EOD__
drop table trnscpt;
create table trnscpt (
SSN char(09),
SEQ char(04),
TXT char(60)
);
__EOD__
The table contains 22+ million records which are formatted so they
can be loaded using the psql copy command.
when an index is built SSN is used. Each SSN can be duplicated 9999 times.
See SEQ.
A 10M record table works just fine.
With a table size of 10 million records the table loads in about 5 hours.
I don't know how long the index creation takes. (I went home after an hour)
select * from trnscpt where ssn = '000000002';
takes just a few seconds and returns headers and good data.
With the full 22M records it stops working. The load/copy was done
over night and two not one files were created.
-rw------- 1 postgres database 26697728 Mar 3 23:20 /u2/pgsql/base/sis/trns
cpt.1
-rw------- 1 postgres database 2147483648 Mar 3 23:16 /u2/pgsql/base/sis/trns
cpt
select * from trnscpt where ssn = '000000002';
returns immediately with no data just headers. The unix od command shows
the data I selected is in the table.
Index creation takes just a few minutes and the same select still fails.
At no time during creation, loading, and use did I receive an error.
Any ideas?!
hal
