Skip to content
Episode 127 - PostgreSQL 12 has some interesting new features, Is it worth the upgrade? episode artwork

Feb 9, 2020 16 min

Episode 127 - PostgreSQL 12 has some interesting new features, Is it worth the upgrade?

from The Backend Engineering Show with Hussein Nasser Hosted by 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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 127 - PostgreSQL 12 has some interesting new features, Is it worth the upgrade?

0:00 16:02

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 16 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on February 9, 2020.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.