search

hammerlab / ketrew

Keep Track of Experimental Workflows
http://www.hammerlab.org/docs/ketrew/master/index.html
Apache License 2.0
74 stars 10 forks source link

Add index to ketrew_main (id) #531

Closed ihodes closed 7 years ago

ihodes commented 7 years ago

This seems to dramatically speed things up

create index ketrew_main_id_idx on ketrew_main (id);

ihodes commented 7 years ago

Also helpful, seemingly:

create index ketrew_main_creation_date on ketrew_main (creation_date); create index km_simple_status on ketrew_main (simple_status); create index km_last_status_change_date on ketrew_main (last_status_change_date);

smondet commented 7 years ago

https://github.com/hammerlab/ketrew/blob/master/src/lib/persistent_data.cppo.ml#L1268-L1277

kserver start
[ketrew] 
    Now debug logs will go to "/tmp/_test_env/logs-of-server/debug.txt" (as
    PID: 4063) (debug-level: 1)
NOTICE:  relation "ketrew_main" already exists, skipping
NOTICE:  relation "ketrew_kill_list" already exists, skipping
NOTICE:  relation "ketrew_add_list" already exists, skipping
NOTICE:  relation "ketrew_main_index_id" already exists, skipping
NOTICE:  relation "ketrew_main_index_creation_date" already exists, skipping
NOTICE:  relation "ketrew_main_index_simple_status" already exists, skipping
NOTICE:  relation "ketrew_main_index_last_status_change_date" already exists, skipping
Persistent_data: fold_active_targets: PGSQL call: start: 2017-06-17-02h46m03s823ms-UTC, got_sql_result: 2017-06-17-02h46m03s834ms-UTC (0.011181)