Scaling Postgres Episode 77 | Timeseries Queries | Arrays | Ranges | C Triggers
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C.
PostgreSQL: Trivial timeseries examples
Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP
How to Get the First or Last Value in a Group Using Group By in SQL
A Faster, Lightweight Trigger Function in C for PostgreSQL
Range Types in PostgreSQL and GiST Indexes
Waiting for PostGIS 3: ST_TileEnvelope(z,x,y)