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

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.

Content Discussed

• Modern data analysis with PostgreSQL – JSONB throws Window functions out the…
• PostgreSQL Security: Things to avoid in real life
• Postgres Full-Text Search: A Search Engine in a Database
• Hacking NFL data with PostgreSQL, TimescaleDB, and SQL
• PostgreSQL Logical Replicas and Snapshots: Proceed Carefully
• Increasing max parallel workers per gather in Postgres
• pgbackrest async behavior
• Deploying Pgpool-II Exporter with Docker
• Improve PostgreSQL Query Performance Insights with pg_stat_monitor
• Roman Druzyagin
• Rubber Duck Dev Show Episode 6 | Handling Exceptions