Versions:
set_number_partitions() CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.
Community
Community functions are available under Timescale Community Edition. Click to learn more.
Sets the number of partitions (slices) of a space dimension on a hypertable. The new partitioning only affects new chunks.
Required arguments
Name | Type | Description |
---|---|---|
hypertable | REGCLASS | Hypertable to update the number of partitions for. |
number_partitions | INTEGER | The new number of partitions for the dimension. Must be greater than 0 and less than 32,768. |
Optional arguments
Name | Type | Description |
---|---|---|
dimension_name | REGCLASS | The name of the space dimension to set the number of partitions for. |
The dimension_name
needs to be explicitly specified only if the
hypertable has more than one space dimension. An error is thrown
otherwise.
Sample usage
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!