PostgreSQL BRIN Index (Block Range Index): 99% Smaller Than B-Tree
Comprehensive guide to PostgreSQL BRIN Index (Block Range Index) — mechanics, 99% RAM and disk space savings vs B-Tree, physical correlation pre-requisite, pages_per_range tuning, and Spring Data JPA integration.
Splunk eval & Time Bucketing (timespan, bin, timechart)
Deep dive into Splunk eval command functions (case, if, coalesce, strftime/strptime) and time bucketing mechanics (bin, bucket, span, timechart, timewrap).
Time-Series Databases
Time-series data characteristics, storage optimizations, InfluxDB, TimescaleDB, Prometheus, and common time-series patterns.
