dbicdh/PostgreSQL/deploy/2/002-extract_crashing_functions.sql
changeset 76 6a33901e2721
parent 61 3a0ca02556da
equal deleted inserted replaced
75:e3912669678c 76:6a33901e2721
    14 -- This extension is the contrib modules
    14 -- This extension is the contrib modules
    15 CREATE EXTENSION IF NOT EXISTS pg_trgm;
    15 CREATE EXTENSION IF NOT EXISTS pg_trgm;
    16 
    16 
    17 -- Used for searching function in the crashing thread backtrace
    17 -- Used for searching function in the crashing thread backtrace
    18 -- Search will be really slow if this index is not present
    18 -- Search will be really slow if this index is not present
    19 CREATE INDEX crash_datas_idx_extract_crashing_functions ON crash_datas USING gin (
    19 CREATE INDEX crash_report_datas_idx_extract_crashing_functions ON crash_report_datas USING gist (
    20     extract_crashing_functions(processed) gin_trgm_ops
    20     extract_crashing_functions(processed) gist_trgm_ops
    21 );
    21 );
    22 
    22