Timeseries Queries, Arrays, Ranges, C Triggers | Scaling Postgres 77
In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/postgresql-trivial-timeseries-examples/
https://www.cybertec-postgresql.com/en/timeseries-exclude-ties-current-row-and-group/
https://hakibenita.com/sql-group-by-first-last-value
https://www.percona.com/blog/2019/08/15/faster-lightweight-trigger-function-in-c-for-postgresql/
https://www.alibabacloud.com/blog/range-types-in-postgresql-and-gist-indexes_595128
https://info.crunchydata.com/blog/waiting-for-postgis-3-st_tileenvelopezxy
Create your
podcast in
minutes
It is Free