I have a huge table which contains signals from various signal sources. I created a hypertable with chunk size set to 1 hour. But I am working towards finding an optimal chunk size and I had a question regarding creating hypertable itself.
Lets say I have table with name “signal_data” that looks like this
The signal with name “valve” has much more data in comparison with signal “airflow”. Is there a way to create two hypertables from one “signal_data” table setting specific chunk sizes for each of these hypertables. If this is possible, will it improve performance?