Select Code to Download

$ time perl llil.pl big1.txt big2.txt big3.txt > big.tmp
llil start
get_properties : 6 secs
...
real    1m28,236s
user    1m27,327s
sys    0m0,816s

CREATE TABLE llil_raw (
    name text,
    count bigint
...

DROP TABLE llil_result;
DROP TABLE llil_raw;

$ time psql -U Earthrise_Server -d Test_DB -f llil.sql 
CREATE TABLE
COPY 3515200
...
real    0m19,675s
user    0m0,022s
sys    0m0,009s