<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi list<div><br></div><div>Context is I’m running v.net.allpairs over a large road network - the output is all combination origin - destination pairs, and the individual line segments that make up a journey path. Individual line segments will appear more than once where they’re common to more than 1 journey paths.</div><div><br></div><div>I’m running PostgreSQL as the db driver.</div><div><br></div><div>If I v.out.postgis, its reassigning cats - which fouls my results. See message below.</div><div><br></div><div>If I v.out.ogr, I don’t experience this problem - except it is unworkably slow e.g. 25 mins for circa 10000 features. The slow speed writing to file, or writing STOUT when PG Driver I haven’t got to the bottom of either?</div><div><br></div><div>v.out.postgis -t is my preferred option, and I then join the attribute tables in PostgreSQL using the cat values - which avoids shovelling data unnecessarily between PostGIS > grass >PostGIS</div><div><br><div><br></div><div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Feature has more categories, using category 9802 (from layer 1)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Feature has more categories, using category 99 (from layer 1)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Feature has more categories, using category 9802 (from layer 1)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Feature has more categories, using category 99 (from layer 1)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 100%</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">WARNING: Feature has more categories, using category 9802 (from layer 1)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">100 features without category or from different layer skipped</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Building topology for vector map <temp_8pg@PERMANENT>...</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Using external data format 'PostgreSQL' (feature type 'linestring')</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Building pseudo-topology over simple features...</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Registering primitives...</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">6613 primitives registered</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">37675 vertices registered</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of nodes: 4710</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of primitives: 6613</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of points: 0</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of lines: 6613</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of boundaries: 0</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of centroids: 0</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of areas: 0</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">Number of isles: 0</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">v.out.postgis complete. 6613 features (linestring type) written to</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><temp_8pg>.</div></div><div><br></div></div></div><div>Hope someone can help - I’m at a critical point in the analysis where I need to scale out the solution.</div><div><br></div><div>Kind regards</div><div>Mark</div></body></html>