2
As you mentioned, your current response is quite fast already, but you could try to run all computations in one query with pgr_dijkstraCostMatrix if you need a full matrix, or recently the shortest path functions also allow so called "combinations" as input,for example https://docs.pgrouting.org/latest/en/pgr_dijkstraCost.html#combinations. This ...
2
Just ST_Union the results:
SELECT ST_AsEncodedPolyline(ST_Union(geom), 5) AS enc
FROM pgr_Dijkstra(
'
SELECT gid AS id, source, target, ST_Length(geom) AS cost
FROM network
',
1,
3000,
FALSE
) AS di
JOIN network AS pt
ON di.edge = pt.gid
;
While precision := 5 is the default, it is ...
1
You could have a look at the set of functions offered by pgRouting in the field of VRP http://docs.pgrouting.org/latest/en/VRP-category.html?highlight=vrp. Some additional information can be found here http://osgeo-org.1560.x6.nabble.com/pgrouting-users-Introduction-to-VRP-with-time-windows-Work-done-in-Gsoc-2014-td5197304.html and here https://github.com/...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
pgrouting × 820postgis × 401
postgresql × 228
openstreetmap × 102
routing × 97
qgis × 80
osm2pgrouting × 77
osm2po × 64
postgis-2.0 × 35
dijkstra × 32
sql × 28
network × 27
shortest-path × 25
osm2pgsql × 17
geoserver × 16
topology × 15
route × 15
openlayers-2 × 14
installation × 13
openlayers × 11
isochrone × 11
ubuntu × 9
distance × 8
astar × 8
travelling-salesman × 8