Sets the number of partitions (slices) of a space dimension on a hypertable. The new partitioning only affects new chunks.
|REGCLASS||Hypertable to update the number of partitions for.|
|INTEGER||The new number of partitions for the dimension. Must be greater than 0 and less than 32,768.|
|REGCLASS||The name of the space dimension to set the number of partitions for.|
dimension_name needs to be explicitly specified only if the
hypertable has more than one space dimension. An error is thrown
For a table with a single space dimension:
SELECT set_number_partitions('conditions', 2);
For a table with more than one space dimension:
SELECT set_number_partitions('conditions', 2, 'device_id');
Found an issue on this page?Report an issue!