News for hackers. Stuff that matters.

A comment on ListenBrainz moves to TimescaleDB. Parent comment

Re:ListenBrainz moves to TimescaleDB by willvarfar on Wednesday July 22, 2020 @02:41PM (#23920193)
Question for influx solution architect:

How do you delete points from a specific measurement in a specific retention policy?

[ Parent | on HN ]
Re:ListenBrainz moves to TimescaleDB by jstrong on Wednesday July 22, 2020 @07:34PM (#23922716)
not a solution architect but, just delete by a very specific timestamp. this is not possible if you are writing at coarse time precisions, so don't do that.

`delete from meas_name where time='2020-07-22T15:40:58.375506762Z'` - just tried that and it deleted one row.

[ Parent | on HN ]
Re:ListenBrainz moves to TimescaleDB by willvarfar on Thursday July 23, 2020 @12:37AM (#23924217)
You didn’t specify the retention policy...?
[ Parent | on HN ]