mblsf

Forget to mention that we are using batch inserts. The values to insert can be for different chunks. For the definition of hypertable definition I need to wait for a...

Here is the requested information. Hope it's complete. If not, please reply. CREATE TABLE IF NOT EXISTS warp_tsa_core.signal_raw_values ( signal_key VARCHAR(50) NOT NULL , raw_ts_utc TIMESTAMP NOT NULL , raw_dupl_id...

This query inserts 153 new entries, it can be up to 1000 entries per query: INSERT INTO signal_raw_values(signal_key, raw_ts_utc, raw_value_num, raw_value_string, raw_state_name, raw_good_flag, load_id) VALUES (%s, %s, %s, %s, %s,...

Maybe our chunk size is too large. What's the recommended uncompressed chunk size for TimescaleDB?

@lkshminarayanan, @sb230132, @RafiaSabih Can someone of you please have a look at this issue again? I think we've recently provided all necessary information.

@mkindahl Here are the results for your query, if still relevant: "warp_tsa_core" "signal_raw_values" "signal_key" 22309 "warp_tsa_core" "signal_raw_values" "raw_ts_utc" 1.261464e+06 "warp_tsa_core" "signal_raw_values" "raw_dupl_id" 1 "warp_tsa_core" "signal_raw_values" "raw_value_num" 143824 "warp_tsa_core" "signal_raw_values" "raw_value_string"...

@mkindahl You're welcome. Please let me know when there are any updates related to this issue.