In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex functions in PG 15. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: <a href= "https://www.cybertec-postgresql.com/en/entity-attribute-value-eav-design-in-postgresql-dont-do-it/"> https://www.cybertec-postgresql.com/en/entity-attribute-value-eav-design-in-postgresql-dont-do-it/</a> <a href= "https://blog.logrocket.com/whats-new-json-postgresql-v14/">https://blog.logrocket.com/whats-new-json-postgresql-v14/</a> <a href= "https://www.enterprisedb.com/blog/aggregate-push-down-mysqlfdw">https://www.enterprisedb.com/blog/aggregate-push-down-mysqlfdw</a> <a href= "https://www.depesz.com/2021/11/26/waiting-for-postgresql-15-add-assorted-new-regexp_xxx-sql-functions/"> https://www.depesz.com/2021/11/26/waiting-for-postgresql-15-add-assorted-new-regexp_xxx-sql-functions/</a> <a href= "https://blog.crunchydata.com/blog/using-timescaledb-extension-with-the-pgo-the-postgres-operator"> https://blog.crunchydata.com/blog/using-timescaledb-extension-with-the-pgo-the-postgres-operator</a> <a href= "https://www.highgo.ca/2021/11/27/how-to-run-a-specific-regression-test/"> https://www.highgo.ca/2021/11/27/how-to-run-a-specific-regression-test/</a> <a href= "https://postgresql.life/post/pavel_luzanov/">https://postgresql.life/post/pavel_luzanov/</a>

Episode 194 Go Faster | GIN Indexes | Collation Stability | PG14 & Beyond

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.