Thanks for all the valuable tips. It's amazing every time how much load a properly configured database can reduce. Especially the tips for optimizing indexes

Thanks for all the valuable tips. It's amazing every time how much load a properly configured database can reduce. Especially the tips for optimizing indexes are very good. "Partial Indexes for Uniqueness Constraints" is my most favorite.