1. 63
  1.  

  2. 9

    I converted from MySQL (before whole MariaDB and fork), and I’ve been happier with every new version. My biggest moment of joy was JSONB and it keeps getting better. Can we please make the connections lighter so that I don’t have to use stuff like pg-bouncer in the middle? I would love to see that in future versions.

    1. 6

      Connections are lighter in Postgres 14!

      1. 5

        Do you have more information about it ? I am interested too :)

        1. 4

          This writeup (not by me) might be of interest: https://pganalyze.com/blog/postgres-14-performance-monitoring

        2. 4

          I am all ears!

          1. 2

            One link is in a reply to other comment in a tree, and some other details can be found from links from this blog post https://www.depesz.com/2020/08/25/waiting-for-postgresql-14-improvements-for-handling-large-number-of-connections/

      2. 6

        PostgreSQL 14 introduces the ability to “bin”, or align, timestamps to a particular interval using the date_bin function

        Exciting news for financial aggregations.

        1. 1

          It’s too bad PostgreSQL isn’t more popular. All my $employers for the last 10 years have picked MySQL, presumably because it was more well-known, and not because they objectively compared against PostgreSQL.