I need a database guru to take a look at an ER diagram I have and assess it for potential performance issues. Some of the tables will have hundreds of millions of records and I'm a bit concerned about the indexing. I would need you to make recommendations on how to modify the database for best performance and why. The db will be a postgreSQL database. I will also need any postrgeSQL weaknesses/features/traits taken into consideration.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).