Scaling Postgres Episode 193 EAV Design, JSON Subscripting, mysql-fdw Push-down, New Regex

To get the show notes as well as get notified of new episodes, visit:

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.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:30 - Entity-attribute-value (EAV) design in PostgreSQL – don’t do it!
04:46 - What’s new with JSON in PostgreSQL v14
06:48 - Aggregate Push-down in mysql_fdw
07:44 - Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.
08:07 - Using TimescaleDB with PGO, the open source Postgres Operator
08:26 - How to run a specific regression test
08:49 - Pavel Luzanov
09:01 - Outro

#postgres #postgresql