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

In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate push-down and new regex functions in PG 15.

Content Discussed

• Entity-attribute-value (EAV) design in PostgreSQL – don’t do it!
• What’s new with JSON in PostgreSQL v14
• Aggregate Push-down in mysql_fdw
• Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.
• Using TimescaleDB with PGO, the open source Postgres Operator
• How to run a specific regression test
• Pavel Luzanov

YouTube Video