Now, PostgreSQL 12 beta-tester is rolling out with performance improvements. This version has performance improvements on many different fronts, including for standard B-tree indexes.
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
PostgreSQL beta 12 adds support for automatically inlining common table expressions - if they are not recursive nor other complications. It enhances the performance by allowing to rebuild indexes concurrently, extended various indexing mechanisms, the lower overhead for the write-ahead log, better performance when processing tables with thousands of partitions, and various other optimizations.
This version also includes the ability to execute JSON path queries, case-insensitive and accent-insensitive comparisons for collations, supports the creation of generated columns, a new pluggable table storage interface, and various other additions.
You can get feature details of this PostgreSQL 12.0 Beta version on PostgreSQL.org.