[pgrouting-users] RAM needed by 'shortest' for planet database

Tao Romera Martinez taoromera at gmail.com
Mon Feb 25 01:22:37 PST 2013


Hello,

I am trying to run 'shortest' on a DB with the routing network of the whole planet. I have indices for the id, source, target and geom columns, and apply a window to limit the data I pass to 'shortest'. However, the postgres server crashes unless the source and target nodes are very close. 

I suspect the problem may come from a lack of RAM since the server only has 1GB, but still have not looked deeper into it. Has anyone put a server running with the whole planet routing network and experienced the same problem? How much memory is needed?

Thanks in advance for any feedback,

Tao




More information about the Pgrouting-users mailing list