Spring Boot R2DBC INSERT batching (Reactive SQL)

Posted on by David Vassallo

Batching is the act of gathering multiple statements together and executing them over a single database connection. Batching has performance benefits since the database can better optimize the batched queries, however it also "saves" having to open individual database connections and reduces connection starvation. Connection starvation in Postgres ends up spitting out errors along the … Continue reading Spring Boot R2DBC INSERT batching (Reactive SQL)

Grafana Prometheus: Detecting anomalies in time series

Posted on by David Vassallo

In our previous post, we explored how we detect anomalies in time series using the 3 sigma rule using Influx. In this article we'll do the same using Grafana https://blog.davidvassallo.me/2021/09/28/influxdb-flux-detecting-anomalies-in-time-series/ As a quick recap, the 3-sigma rule states that approximately all our "normal" data should be within 3 standard deviations of the average value of … Continue reading Grafana Prometheus: Detecting anomalies in time series