Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 3 down vote favorite

I have just imported a Spatialite database into Postgresql/Postgis. The problem is: using Qgis to work with them is much slower in Postgis (spatial indexes created) than doing the same in Spatialite.

Is there any way to improve Postgis layers speed in Qgis?

EDIT:

Postgis is running on an external server while Spatialite database is on my local PC. Previously, I thought Qgis would cache all my loaded layers onto local disk, I just checked and found that I was wrong - every time I pan around in Qgis, network traffic on my Postgis database increase (right now I am the only one using this experimenting server).

Is there any way to make Qgis cache data locally to improve speed?

share|improve this question
1  
That has never been my experience. PostGIS has always felt faster then Spatialite to me. – Nathan W Jan 14 at 5:36
@NathanW: thank you for your interest. I added information in the question above. Would you please give me some ideas on situation like this? – Cao Minh Tu Jan 14 at 8:01
Have you adjusted your PostgreSQL server pga_hba.conf values to match your usage. Default memeory usage is quite small. – simplexio Jan 14 at 8:07
2  
QGIS has no caching every request is live. – Nathan W Jan 14 at 9:25
@simplexio: Thanks. I am reading the web on how to tune PostGIS. Do you recommend any source? – Cao Minh Tu Jan 15 at 1:44
show 2 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.