Eight tips to relieve those Postgres headaches
Postgres is my Swiss army knife for storage and can cover the traditional relational database usecases, extreme scaling, NoSQL use-cases, analytics and much more. It's a great stack to start with and only after a long period of time you will see if you actually need something more specialized.
Here's a few helpful tips on the productboard engineering blog to make work with it even smoother, check it out.