1. A computer-implemented method comprising: receiving, by a database system, a first insert request identifying a hypertable and one or more input records for inserting in the hypertable, each record having a plurality of attributes including a set of dimension attributes, the set of dimension attributes including a time attribute, wherein the hypertable represents a database table partitioned into chunks along the set of dimension attributes, the chunks distributed across a first plurality of locations, wherein each location comprises a distinct storage device and each chunk is associated with a set of values corresponding to each dimension attribute, such that, for each record stored in the chunk, and for each dimension attribute of the record, the value of the dimension attribute of the record maps to a value from the set of values for that dimension attribute as specified by the chunk; responsive to receiving the first insert request for inserting the records in the hypertable, storing the one or more records specified in the first insert request in chunks created according to a first partitioning policy, the first partitioning policy specifying a size of a first plurality of chunks to be created and a mapping from each of the first plurality of chunks to a location from the first plurality of locations for storing the chunk, wherein each of the one or more records is inserted in a chunk from the first plurality of chunks based on the values of dimension attributes of the record; receiving an indication of an addition of one or more new locations to the database system, the addition causing the database system to have a second plurality of locations, wherein the indication is associated with a reconfiguration time; creating a second plurality of chunks subsequent to receiving the indication of the addition of the one or more new locations, the second plurality of chunks created according to a second partitioning policy, the second partitioning policy specifying a size of a second plurality of chunks to be created and a mapping from each of the second plurality of chunks to a location from the second plurality of locations, and wherein subsequent to receiving the indication of the addition of the one or more new locations, the distribution of the first plurality of chunks is maintained according to the first partitioning policy; receiving a second insert request to insert one or more records into the database table subsequent to receiving the indication of the addition of one or more new locations to the database system; and responsive to receiving the second insert request, for each of the one or more records specified in the second insert request, storing the record in a chunk selected based on the values of dimension attributes of the record.