
Scaling Postgres Episode 24 | Full Text Search | JSONB_AGG | Upgrades | CIS
Get New Episodes Weekly!
In this episode of Scaling Postgres, we review articles covering full text search, aggregating JSON with jsonb_agg, upgrades and CIS benchmarks.
Content Discussed
- Setting Up a Fast, Comprehensive Search Routine With PostgreSQL
- SQL Tip: JSONB_AGG in PostgreSQL for simple one-to-many joins
- Meetup PostgreSQL - How PostgreSQL's SQL dialect stays ahead
- Upgrading PostgreSQL on AWS RDS with minimum or zero downtime
- Using the CIS PostgreSQL Benchmark to Enhance Your Security
- Designing the most performant Row Level Security schema in Postgres
- New Webinar: An Introduction to Performance Monitoring for PostgreSQL
- PostgreSQL Triggers and Stored Function Basics
- Understanding And Reading the PostgreSQL System Catalog