A computer-implemented method comprising: receiving, by a database system, an insert request, the 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 a plurality of chunks along the set of dimension attributes, each chunk 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; for each of the one or more input records, determining whether the input record should be stored in a new chunk to be created, the determining based on the values of dimension attributes of the input record; responsive to determining that an input record should be stored in a new chunk to be created, determining sets of values corresponding to each dimension attribute for the new chunk to be created wherein determining sets of values for a dimension attribute for the new chunk comprises: maintaining statistics describing queries processing chunks, and determining sets of values of dimension attributes of the new chunk based on the statistics describing queries processing chunks; dynamically creating a new chunk for storing the input record, the new chunk associated with the determined sets of values corresponding to each dimension attribute; updating the hypertable by storing the input record in the new chunk; and processing the data stored in the updated hypertable in response to one or more subsequent queries identifying the hypertable. receiving, by a database system, an insert request, the 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 a plurality of chunks along the set of dimension attributes, each chunk 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; for each of the one or more input records, determining whether the input record should be stored in a new chunk to be created, the determining based on the values of dimension attributes of the input record; responsive to determining that an input record should be stored in a new chunk to be created, determining sets of values corresponding to each dimension attribute for the new chunk to be created wherein determining sets of values for a dimension attribute for the new chunk comprises: maintaining statistics describing queries processing chunks, and determining sets of values of dimension attributes of the new chunk based on the statistics describing queries processing chunks; maintaining statistics describing queries processing chunks, and determining sets of values of dimension attributes of the new chunk based on the statistics describing queries processing chunks; dynamically creating a new chunk for storing the input record, the new chunk associated with the determined sets of values corresponding to each dimension attribute; updating the hypertable by storing the input record in the new chunk; and processing the data stored in the updated hypertable in response to one or more subsequent queries identifying the hypertable. <EOS>