Scaling Postgres

In this episode of Scaling Postgres, we discuss JSONB vs. window functions, a Postgres security checklist, implementing full-text search and using NFL timeseries data. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://swarm64.com/post/postgresql-jsonb-vs-window-functions/ https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/ https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database https://blog.timescale.com/blog/hacking-nfl-data-with-postgresql-timescaledb-and-sql/ https://ardentperf.com/2021/07/26/postgresql-logical-replicas-and-snapshots-proceed-carefully/ https://www.pgmustard.com/blog/max-parallel-workers-per-gather https://fluca1978.github.io/2021/07/27/pgbackrestAsync.html https://b-peng.blogspot.com/2021/07/deploying-pgpool2-exporter-with-docker.html https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/ https:/