timescaledb icon indicating copy to clipboard operation
timescaledb copied to clipboard

[Feature]: Drop a chunk by name

Open lmandras-iura opened this issue 5 months ago • 3 comments

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

lmandras-iura avatar Aug 27 '24 15:08 lmandras-iura