Episode 127 - PostgreSQL 12 has some interesting new features, Is it worth the upgrade‪?‬ The Backend Engineering Show with Hussein Nasser

PostgresSQL version 12 has been released, let's go through the features that I think are most interesting and cool. #softwarenews 
 Feature Matrix https://www.postgresql.org/about/featurematrix/  
- Allow adding columns to Index (GIST) https://www.postgresql.org/about/featurematrix/detail/314/ 
- COPY FROM WHERE COPY FROM ... WHERE 
- More native support of JSON objects https://www.postgresql.org/docs/12/functions-json.html#FUNCTIONS-SQLJSON-PATH 
- Reindex concurrently (slow but allows writes) https://www.postgresql.org/docs/12/sql-reindex.html#SQL-REINDEX-CONCURRENTLY
- Performance on large partitioned tables - Stored Generated Columns