How to Optimize MySQL and PostgreSQL

You can set up an index for every single field in your database, but it doesn't make sense if you never use the index. And this is just going to blow up your database storage capacities or the need for that. I would rather say go without index until you see a problem and then add it. If you not really spent a lot of time on learning Postgres and reading books and stuff, but if you just want to learn something on the side, maybe follow Tobias Petrie.