Tagged Questions
8
votes
3answers
249 views
How to speed up queries for raster databases?
I have a raster database in postgresql/postgis with these columns:
(ID, rast, data_of_data).
'rast' is the column that has raster files in WKT format. An example query to find the DN value of a ...
4
votes
1answer
199 views
Improve database performance for geospatial
I have a database with osm data imported with osmosis tool. I want to search for the nearest POIs from a given point. For this purpose, I perform this query:
select id from nodes
where ...
6
votes
3answers
163 views
What would be 'normal' processing time for a large postgis query
I have two datasets which I want to spatially join (with an intersect).
The first dataset consists of 9 million addresses. The second dataset consists of 12.000 neighbourhoods. I want the add the ...
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 ( ...
