Scaling Postgres

Timeseries Queries, Arrays, Ranges, C Triggers | Scaling Postgres 77

Informações:

Synopsis

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