> Don't reinvent a type system I'd like to add: stay away from using arrays and user defined types. They feel like a good idea at first, but will become a prob

> Don't reinvent a type system I'd like to add: stay away from using arrays and user defined types. They feel like a good idea at first, but will become a problem when using fetched data in your code. And another miss, if you're managing your servers: pgtune. The default postgres configuration is very conservative regarding resources so you can get good performance gains just by adjusting them to your server specifications.