1. 7
  1.  

  2. 3

    A few of my other favorite features

    • Transactional DDL – Being able to run my Rails migrations in atomic steps has been invaluable.
    • Concurrent indexing – You don’t have to take long lived table locks in order to add an index.
    • Sane defaults – Postgres’s defaults don’t let you silently lose data to truncation, and are tuned reasonably well for an average production environment.
    1. 1

      TIL about window!

      1. 1

        If you have never used Postgres you owe it to yourself to give it a shot. It’s really well designed and has a ton of features, as shown by this article. The best thing I transactional ddl, it’s saved me more times then I’d like to admit.