Hi everyone,
First of all, being new here, I am a “young” programmer following a recent professional transition, and I’m new to timescaledb. So nice to forumlly meets you !
I’m working on a use case that require replacement of historical data. Chunk are compressed.
As timestampz will most likely not match recorded ones, I’m assuming that I’ll need to delete former recorded data first, then backfill with the new ones.
As far as I’ve understand the documentation, in order to delete historical data, I have to decompress > delete > compress.
I would then proceed as if I was only backfilling data, using a temporary secondary table and the decompress_backfill procedure.
Would this be the correct, best practice way to handle this type of use case ?
Is there any secondary effect I might not be aware of ? So far I don’t think that we have any aggregated data.
Thank you !