
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.
Content Discussed
- 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)