15 min listen
Episode 127 - PostgreSQL 12 has some interesting new features, Is it worth the upgrade?
Episode 127 - PostgreSQL 12 has some interesting new features, Is it worth the upgrade?
ratings:
Length:
16 minutes
Released:
Feb 9, 2020
Format:
Podcast episode
Description
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
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
Released:
Feb 9, 2020
Format:
Podcast episode
Titles in the series (100)
Episode 01 - Sync vs aSync by The Backend Engineering Show with Hussein Nasser