TimeScale and drop_chunks, DCI disk usage
-
Anyone else using timescaledb with postgres?
When I look at timescaledb maintenance, typically the drop_chunks function would be used to reclaim disk space. However, drop_chunks requires TIMESTAMP, TIMESTAMPTZ, or DATE column types. For 'idata' and 'tdata', for example, the timestamp column is actually an int4.
Any pointers on how to determine whether NetXMS is actually pruning old entries to reclaim disk space? It's certainly dropping DCIs correctly from an access standpoint -- queries only return the expected time ranges.
-
drop_chunks requires TIMESTAMP, TIMESTAMPTZ or DATE if the cut-off point is set as an interval.
If the cut-off point is given explicitly, you can use integers, see https://docs.timescale.com/latest/api#drop_chunks
As NetXMS uses integers in its current cleanup queries, I would assume it will use explicit cut-off points for drop_chunks as well.
Note that I'm not a dev and haven't looked at the code... -
Yes, NetXMS uses explicit cutoff points for dropping chunks. But please note that TimescaleDB support in 2.2.16 is quite immature - we have improved it significantly in 3.0 branch.
Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login