Scaling Postgres Episode 176 JSONB vs. Window Functions | Security Checklist | Full-Text Search

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss JSONB vs. window functions, a Postgres security checklist, implementing full-text search and using NFL time-series data.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:29 - Modern data analysis with PostgreSQL – JSONB throws Window functions out the…
03:41 - PostgreSQL Security: Things to avoid in real life
08:17 - Postgres Full-Text Search: A Search Engine in a Database
11:08 - Hacking NFL data with PostgreSQL, TimescaleDB, and SQL
12:16 - PostgreSQL Logical Replicas and Snapshots: Proceed Carefully
13:43 - Increasing max parallel workers per gather in Postgres
15:11 - pgbackrest async behavior
16:41 - Deploying Pgpool-II Exporter with Docker
17:00 - Improve PostgreSQL Query Performance Insights with pg_stat_monitor
17:53 - Roman Druzyagin
18:06 - Rubber Duck Dev Show Episode 6 | Handling Exceptions
18:26 - Outro

#postgres #postgresql