how to Speed up the query execution in a bulky database

[aradhanathawait]

I m working on postgresql8.2.4 and struts. Earlier a report based on join queries was displayed faster. But as the no. of records go on increasing the report is not displayed completely. I tried to increase the shared_buffer parameter in postgresql.conf . But it didn't help much . Please guide me .
Its urgent.

Thanx n regards,
Aradhana

[rski]

You think the problem is database or struts (java struts I guess)?
What is the plan for that query. Maybe you should sow that query here.