Database administrator -- 3

We have developed web application in which we have provided some search for our user can search report as per requirement. And we have more the 50 + countries data in different different formats and now we have upload 150 GB data in postgresql. But there is problem that database query very slow so I need improve our database performance.