Tagged Questions
3
votes
3answers
2k views
How to fix performance problem in PostGIS ST_Intersects?
I'm a newbie in postgis and I have a problem in query performance.
This my query:
SELECT DISTINCT ON (userid) userid ,ST_AsText(position), timestamp
FROM table1
WHERE ST_Intersects ( ...
4
votes
2answers
682 views
Qgis is slow with complex 'postgis query' layer. How to speed up?
I have a postgis layer in Qgis that is a result of a complex query. Every screen update, Qgis runs the Query again and that's slow.
Any suggestion on how to speed up?
EDIT - Here is the query:
...
11
votes
4answers
1k views
Speeding up OpenStreetMap PostGIS querying
I have OpenStreetMap data for the Netherlands loaded into a PostGIS database (PostgreSQL 8.3 / PostGIS 1.3.3) using the osmosis schema. This means all tags are stored in a hstore field. In addition to ...
19
votes
5answers
5k views
Optimizing osm2pgsql imports for OSM data
I'm currently building an instance on EC2 on which to import the entire Planet.osm snapshot of the whole Earth's worth of data for some projects we're working on. I've spun up a large Ubuntu x64 ...
2
votes
2answers
1k views
Postgres/PostGIS Spatial Query Performance Problem
I have a query in Postgres/PostGIS that I am a bit confused about. The spatial intersection happens very fast, ~ 2 seconds for 10,000, but the update takes > 15 seconds for the same number of points.
...
