We’ve collected a bunch of videos which explain all the new major features in one of our long-time favorite SQL databases – PostgreSQL. Version 10 was released in the fall of 2017. I’ve been using PostgreSQL since my first IT job doing Perl CGI development, right out of 12th Grade, so it is near and dear to my heart. For something to read regarding version 10, check the PostgreSQL documentation, or this blog post about replication and table partitions.
My favorite feature is probably the parallel query execution, which allows a single query to be broken down and executed on multiple CPU cores for a huge performance increase.
I see that PostgreSQL 11 is coming out soonish, need to go check that out next….