Implement time_bucket_gapfill_ng()

[sooand]

What type of enhancement is this?

User experience

What subsystems and features will be improved?

Gapfill

What does the enhancement do?

Right now to do time_buckets by non fixed times e.g yearly, monthly and quarterly we need to use timescaledb_experimental.time_bucket_ng. Which seems to work. But I can't seem to find any way to gapfill results like time_bucket_gapfill. I would expect a similar function: timescaledb_experimental.time_bucket_ng_gapfill

SME: @svenklemm

Implementation challenges

what time_bucket_gapfill is to time_bucket should timescaledb_experimental.time_bucket_ng_gapfill be to timescaledb_experimental.time_bucket_ng

• Tests: https://github.com/timescale/product/issues/147

---

References

• Support time_bucket_gapfill in continuous aggregates #1324
• time_bucket_gapfill is not working when trying to offset the timestamp #1435
• support for offset and origin options in time_bucket_gapfill #3212