timescaledb
timescaledb copied to clipboard
[Feature]: Drop a chunk by name
What problem does the new feature solve?
I need to deleted data based on the segment_by column (eg: device ID). Given i have a device ID, delete all chunks (including compressed) that belong to that device ID.
The point being to not use a regular DELETE sql statement that will have to decompress those chunks first and then run the delete. For GDPR purposes if i want to erase all data related to a device ID i want to do it as fast and simple as possible.
What does the feature do?
Drop/delete a chunk (including compressed) based on the chunk name (there is a query to get all chunks for a certain segment by value)
Implementation challenges
No response