7,593 reputation
11224
bio website blog.jordogskog.no
location Hedmark, Norway
age
visits member for 3 years, 11 months
seen 5 hours ago

17h
answered Postgres Performance with Radius Searches
Aug
27
revised Is there a PostGIS function to get a tangent and normal line?
added 2 characters in body
Aug
27
answered Is there a PostGIS function to get a tangent and normal line?
Aug
11
awarded  Caucus
Aug
5
comment C# geometry hex decoder
Do you mean that you have no control over the actual query? That seems like making things hard. What you have is wkb as hex values. So you need to read wkb and make that readable for whatever you are going to feed it into.
Aug
4
answered postGIS: what is more efficient: single or two-point search
Jul
20
answered What is the internal format of PostGIS?
Jul
19
revised ST_ClosestPoint in 2D but retaining Z value
added 71 characters in body
Jul
19
revised ST_ClosestPoint in 2D but retaining Z value
added 71 characters in body
Jul
19
answered ST_ClosestPoint in 2D but retaining Z value
Jul
18
revised How to add a new permanent column that contains result from ST_AREA select queries
added 24 characters in body
Jul
18
revised How to add a new permanent column that contains result from ST_AREA select queries
added 196 characters in body
Jul
18
answered How to add a new permanent column that contains result from ST_AREA select queries
Jul
18
comment Growth of a PostGIS database for Social Media - Move to Cassandra?
@Jay Cummins, I agree that the question isn't about query design and indexing. But to buy more ram before tuning the query seems like starting in the wrong end. That is more the microsoft/esri way of doing things :-)
Jul
18
comment Growth of a PostGIS database for Social Media - Move to Cassandra?
@mikedotonline ok, but do you have a spatial index that is functional?
Jul
17
comment Growth of a PostGIS database for Social Media - Move to Cassandra?
BTW, you say that you do the selection spatially, but you are also talking about many indexed columns. Why do you have many indexed columns if you don't use them for the selection?
Jul
17
comment Growth of a PostGIS database for Social Media - Move to Cassandra?
Ok, but still. If you have a working spatial index on the geometries I cannot understand that it should take that long time. 350 mill records is not that much.
Jul
17
comment Growth of a PostGIS database for Social Media - Move to Cassandra?
Are you sure it is the selection that is slow and not just the output of all the data. I mean an index search on a integer field like postal codes on 350 mill rows shouldn't be that slow I think.
Jun
16
answered Is it best to use multipolygon or polygon features for large intersect operations?
Jun
16
comment Is it best to use multipolygon or polygon features for large intersect operations?
ST_Split is not the right function here. It will just split the polygon. Use ST_Intersection to get the interesecting part.