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.
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.
A few of my other favorite features
TIL about window!
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.