Scaling Postgres

In this episode of Scaling Postgres, we review articles covering full text search, aggregating JSON with jsonb_agg, upgrades and CIS benchmarks. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://rob.conery.io/2018/07/23/setting-up-a-fast-comprehensive-search-routine-with-postgresql/   https://medium.com/@geekuillaume/sql-tip-jsonb-agg-in-postgresql-for-simple-one-to-many-joins-bde8caa30c46   https://www.youtube.com/watch?v=lL6g9PHHin4   https://medium.com/preply-engineering/postgres-multimaster-34f2446d5e14   https://info.crunchydata.com/blog/using-the-cis-postgresql-benchmark-to-enhance-your-security   https://medium.com/@cazzer/designing-the-most-performant-row-level-security-strategy-in-postgres-a06084f31945   https://severalnines.com/blog/new-webinar-introduction-performance-monitoring-postgresql   https://severalnines.com/blog/postgresql-triggers-and-stored-function-basics   https://severalnines.com/blog/understanding-a