cybertec-postgresql / pgwatch / 19174648345

74%

push

github

[+] support variable partition intervals in postgres sink (#1012)

* [+] allow to specify interval for Postgres partitioning

`admin.ensure_partition_metric_dbname_time()` acccepts now
partition_period interval. The naming format is 'YYYYMMDD' for intervals
bigger than 1 day and 'YYYYMMDD_HH24' for hour-based intervals.
The function finds the last available partition bound and creates
new partition based on it. So it's possible to use mixed length
partitions, possibly with scheduler based on monitored source and/or
metrics.

* Add new `PartitionInterval` cli parameter.

* Use `PartitionInterval` parameter in `EnsureMetricDbnameTime()`

* Mention `--partition-interval` in docs.

* Add validation logic for `PartitionInterval`

* Add test for `PartitionInterval` validation

* Test actual partitions creation

* Add example usage of `--partition-interval` in docs.

---------

Co-authored-by: Pavlo Golub <pavlo.golub@gmail.com>

10 of 11 new or added lines in 1 file covered. (90.91%)

3570 of 4969 relevant lines covered (71.85%)

0.82 hits per line