
Scaling Postgres Episode 176 JSONB vs. Window Functions | Security Checklist | Full-Text Search | NFL Time-Series
Get New Episodes Weekly!
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
- pgbackrest async behavior
- 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
- 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