root/sql/tables/noit.metric_numeric_rollup_5m.sql

Revision 4e7af0052829e39e8da8375b559e9be499b247c2, 1.4 kB (checked in by Robert Treat <robert@omniti.com>, 5 years ago)

store data in chunks as array values to save storage space

  • Property mode set to 100644
Line 
1 -- formerly rollup_matrix_numberic_5m
2
3 --
4 -- PostgreSQL database dump
5 --
6
7 SET client_encoding = 'UTF8';
8 SET standard_conforming_strings = off;
9 SET check_function_bodies = false;
10 SET client_min_messages = warning;
11 SET escape_string_warning = off;
12
13 SET search_path = noit, pg_catalog;
14
15 SET default_tablespace = '';
16
17 SET default_with_oids = false;
18
19 --
20 -- Name: metric_numeric_rollup_5m; Type: TABLE; Schema: noit; Owner: postgres; Tablespace:
21 --
22
23 CREATE 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
33 ALTER 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
39 ALTER 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
47 REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM PUBLIC;
48 REVOKE ALL ON TABLE metric_numeric_rollup_5m FROM postgres;
49 GRANT ALL ON TABLE metric_numeric_rollup_5m TO postgres;
50 GRANT ALL ON TABLE metric_numeric_rollup_5m TO reconnoiter;
51 GRANT SELECT ON TABLE metric_numeric_rollup_5m TO prism;
52 GRANT ALL ON TABLE metric_numeric_rollup_5m TO stratcon;
53
54
55 --
56 -- PostgreSQL database dump complete
57 --
58
Note: See TracBrowser for help on using the browser.