Sign up ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

After read this nice post from underdark A Beginner’s Guide to pgRouting, although I still have some little problems, I think I can begin the "Creating a routable road network" stage right now.

I got a polyline shapefile already, but after I Add PostGIS Layers, I open PostGIS Manager and I don't know if these two red triangles would bother me later on:

  • There is a significant difference between estimated and real row count. Consider running VACCUUM ANALYZE.
  • No spatial index defined.

If they do, what can I do?

enter image description here

share|improve this question
You should post new questions for each question. That way you will get better, focused answers. – Devdatta Tengshe Apr 3 '13 at 8:17
Please post one question per thread. I'll remove the last three questions from this one. – underdark Apr 3 '13 at 9:30
Thanks for reminding me. – Heinz Apr 3 '13 at 9:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.