Hi, I'm looking for a solution to a performance problem we're having.

We have an web application with Postgres 9.1 database. We created a DB view for user interface which displays all the relevant information for the user, but because of the DB table structure, the query for this view executes very slow, as it needs to access multiple tables and transpose a lot of data (query takes about 4-5 seconds). We tried fixing this by using materialized views available in 9.3 version and it improved the query time 10x, but it seems not usable until refresh CONCURRENTLY will be available in 9.4 (?).

I'm looking for advice for the matter.