Show
Ignore:
Timestamp:
09/29/09 20:22:36 (5 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1254255756 +0000
git-parent:

[a34bc1266a0a4f7fa69f17c5957f160162a4398d]

git-author:
Robert Treat <robert@omniti.com> 1254255756 +0000
Message:

store data in chunks as array values to save storage space

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/tables/noit.metric_numeric_rollup_5m.sql

    ra34bc12 r4e7af00  
    11-- formerly rollup_matrix_numberic_5m 
     2 
     3-- 
     4-- PostgreSQL database dump 
     5-- 
     6 
     7SET client_encoding = 'UTF8'; 
     8SET standard_conforming_strings = off; 
     9SET check_function_bodies = false; 
     10SET client_min_messages = warning; 
     11SET escape_string_warning = off; 
     12 
     13SET search_path = noit, pg_catalog; 
     14 
     15SET default_tablespace = ''; 
     16 
     17SET default_with_oids = false; 
     18 
     19-- 
     20-- Name: metric_numeric_rollup_5m; Type: TABLE; Schema: noit; Owner: postgres; Tablespace:  
     21-- 
     22 
     23CREATE TABLE metric_numeric_rollup_5m ( 
     24    sid integer NOT NULL, 
     25    name text NOT NULL, 
     26    rollup_time timestamp with time zone NOT NULL, 
     27    count_rows integer[], 
     28    avg_value numeric[], 
     29    counter_dev numeric[] 
     30); 
     31 
     32 
     33ALTER TABLE metric_numeric_rollup_5m OWNER TO postgres; 
     34 
     35-- 
     36-- Name: fmetric_numeric_rollup_5m_pkey; Type: CONSTRAINT; Schema: noit; Owner: postgres; Tablespace:  
     37-- 
     38 
     39ALTER TABLE ONLY metric_numeric_rollup_5m 
     40    ADD CONSTRAINT fmetric_numeric_rollup_5m_pkey PRIMARY KEY (rollup_time, sid, name); 
     41 
     42 
     43-- 
     44-- Name: metric_numeric_rollup_5m; Type: ACL; Schema: noit; Owner: postgres 
     45-- 
     46 
     47REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM PUBLIC; 
     48REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM postgres; 
     49GRANT ALL ON TABLE metric_numeric_rollup_5m TO postgres; 
     50GRANT ALL ON TABLE metric_numeric_rollup_5m TO reconnoiter; 
     51GRANT SELECT ON TABLE metric_numeric_rollup_5m TO prism; 
     52GRANT ALL ON TABLE metric_numeric_rollup_5m TO stratcon; 
     53 
     54 
     55-- 
     56-- PostgreSQL database dump complete 
     57-- 
     58