equal
deleted
inserted
replaced
42 Index it however you please based on how you intend to query the data, |
42 Index it however you please based on how you intend to query the data, |
43 including JSON functional indexing, etc. See PostgreSQL documentation |
43 including JSON functional indexing, etc. See PostgreSQL documentation |
44 for details. |
44 for details. |
45 |
45 |
46 Strongly encouraged: Promote this table to a Timescale "hypertable". |
46 Strongly encouraged: Promote this table to a Timescale "hypertable". |
47 See Timescale docs for that. |
47 See Timescale docs for that, but a quick example to partition |
|
48 automatically at weekly boundaries would look something like: |
|
49 |
|
50 ```sql |
|
51 SELECT create_hypertable( 'netdata', 'time', chunk_time_interval => 604800000000 ); |
|
52 ``` |
48 |
53 |
49 |
54 |
50 |
55 |
51 ### Netdata |
56 ### Netdata |
52 |
57 |