Show
Ignore:
Timestamp:
09/25/08 01:18:36 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1222305516 +0000
git-parent:

[cbb1d8e025f39b356b154b10978d5c4139ad52db]

git-author:
Denish Patel <denish@omniti.com> 1222305516 +0000
Message:

added index

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/reconnoiter_ddl_dump.sql

    r75075e2 r43ec19a  
    11491149ref_hostname text; 
    11501150ref_metric_name text; 
     1151ref_alias text; 
    11511152v_ts_search_all tsvector; 
    11521153BEGIN 
     
    11701171     WHERE module='dns' AND s.name='in-addr.arpa' AND target = ref_target; 
    11711172 
     1173    SELECT mt.value INTO ref_alias 
     1174      FROM stratcon.current_metric_text mt 
     1175      JOIN stratcon.mv_loading_dock_check_s s USING(sid) 
     1176     WHERE s.module='snmp' AND mt.name='alias' AND s.sid=in_sid; 
     1177 
    11721178    ref_hostname := coalesce(replace(ref_hostname, '.', ' '), ' '); 
    11731179    ref_metric_name := regexp_replace(in_metric_name, E'[_\`/.\\134]', ' ', 'g'); 
     1180    ref_alias := coalesce(regexp_replace(ref_alias, E'[_\`/.\\134]', ' ', 'g'), ' '); 
    11741181 
    11751182    v_ts_search_all=to_tsvector(ref_metric_name || ' ' || 
     
    11781185                                ref_target || ' ' || 
    11791186                                ref_hostname || ' ' || 
     1187                                ref_alias || ' ' || 
    11801188                                ref_tags); 
    11811189    RETURN v_ts_search_all; 
     
    22022210 
    22032211-- 
     2212-- Name: idx_metric_name_summary_ts_search_all; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
     2213-- 
     2214 
     2215CREATE INDEX idx_metric_name_summary_ts_search_all ON metric_name_summary USING btree (ts_search_all); 
     2216 
     2217 
     2218-- 
    22042219-- Name: idx_mv_loading_dock_check_s_module; Type: INDEX; Schema: stratcon; Owner: reconnoiter; Tablespace:  
    22052220--