Changes between Version 3 and Version 4 of OqaFma


Ignore:
Timestamp:
03/02/12 08:52:27 (6 years ago)
Author:
joshuadf
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • OqaFma

    v3 v4  
    5959{{{ 
    6060# as user oqafma 
    61 cat > oqafma-base.sql <<EOF 
    62 CREATE TABLE "fm" ( 
    63         "frame" integer NOT NULL, 
    64         "frame_type" smallint NOT NULL, 
    65         "slot" integer NOT NULL, 
    66         "facet" integer NOT NULL, 
    67         "is_template" smallint NOT NULL, 
    68         "value_index" integer NOT NULL, 
    69         "value_type" smallint NOT NULL, 
    70         "short_value" character varying(255), 
    71         "long_value" text 
    72 ); 
    73  
    74 CREATE TABLE "time_stamp" ( 
    75         "stamp" timestamp with time zone 
    76 ); 
    77 INSERT INTO time_stamp(stamp) VALUES (CURRENT_TIMESTAMP); 
    78  
    79 CREATE INDEX fm_findex ON fm USING btree (frame); 
    80 CREATE INDEX fm_fsftindex ON fm USING btree (frame, slot, facet, is_template); 
    81 CREATE INDEX fm_sftvindex ON fm USING btree (slot, facet, is_template, short_value); 
    82 CREATE INDEX fm_vindex ON fm USING btree (short_value); 
    83 EOF 
    84 psql -h localhost --user oqafma_user OQAFMA  < oqafma-base.sql 
     61PQL=/home/oqafma/bin/newq.psql 
     62psql -h localhost --user oqafma_user OQAFMA  < $PQL 
    8563# enter pass 
    86 psql -h localhost --user oqafma_user testOQAFMA  < oqafma-base.sql 
     64psql -h localhost --user oqafma_user testOQAFMA  < $PQL 
    8765# enter pass 
    8866# next step takes many hours, see below for info