equal
deleted
inserted
replaced
42 functional indexing, etc. See PostgreSQL documentation for details. |
42 functional indexing, etc. See PostgreSQL documentation for details. |
43 |
43 |
44 Strongly encouraged: Promote this table to a Timescale "hypertable". |
44 Strongly encouraged: Promote this table to a Timescale "hypertable". |
45 See [Timescale](http://timescale.com) docs for that, but a quick example |
45 See [Timescale](http://timescale.com) docs for that, but a quick example |
46 to partition automatically at weekly boundaries would look something |
46 to partition automatically at weekly boundaries would look something |
47 like: |
47 like this, if you're running v0.9.0 or better: |
48 |
48 |
49 ```sql |
49 ```sql |
50 SELECT create_hypertable( 'netdata', 'time', chunk_time_interval => 604800000000 ); |
50 SELECT create_hypertable( 'netdata', 'time', migrate_data => true, chunk_time_interval => '1 week'::interval ); |
51 ``` |
51 ``` |
52 |
52 |
53 Timescale also has some great examples and advice for efficient [JSON |
53 Timescale also has some great examples and advice for efficient [JSON |
54 indexing](http://docs.timescale.com/v0.8/using-timescaledb/schema-management#json) |
54 indexing](http://docs.timescale.com/v0.8/using-timescaledb/schema-management#json) |
55 and queries. |
55 and queries. |