Scaling Postgres Episode 77 | Timeseries Queries | Arrays | Ranges | C Triggers
Subscribe at https://www.scalingpostgres.com to get notified of new episodes. In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C. Timestamps: 00:00 - Intro 00:23 - PostgreSQL: Trivial timeseries examples 02:03 - Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP 05:36 - How to Get the First or Last Value in a Group Using Group By in SQL 07:48 - Range Types in PostgreSQL and GiST Indexes 09:05 - A Faster, Lightweight Trigger Function in C for PostgreSQL 11:29 - Waiting for PostGIS 3: ST_TileEnvelope(z,x,y) 11:51 - Outro #postgres #postgresql
Subscribe at https://www.scalingpostgres.com to get notified of new episodes. In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C. Timestamps: 00:00 - Intro 00:23 - PostgreSQL: Trivial timeseries examples 02:03 - Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP 05:36 - How to Get the First or Last Value in a Group Using Group By in SQL 07:48 - Range Types in PostgreSQL and GiST Indexes 09:05 - A Faster, Lightweight Trigger Function in C for PostgreSQL 11:29 - Waiting for PostGIS 3: ST_TileEnvelope(z,x,y) 11:51 - Outro #postgres #postgresql