Scaling Postgres

Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193

Informações:

Synopsis

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: https://www.cybertec-postgresql.com/en/entity-attribute-value-eav-design-in-postgresql-dont-do-it/ https://blog.logrocket.com/whats-new-json-postgresql-v14/ https://www.enterprisedb.com/blog/aggregate-push-down-mysqlfdw https://www.depesz.com/2021/11/26/waiting-for-postgresql-15-add-assorted-new-regexp_xxx-sql-functions/ https://blog.crunchydata.com/blog/using-timescaledb-extension-with-the-pgo-the-postgres-operator https://www.highgo.ca/2021/11/27/how-to-run-a-specific-regression-test/ https://postgresql.life/post/pavel_luzanov/