developer (#13) - Make pgroute faster (#299) - Message List

Make pgroute faster

Hi all,

i have all Turkey road data including about 1600000 edges.. i prepared data with the help of what mentioned at http://pgrouting.postlbs.org/wiki/WorkshopFOSS4G2008/ch06#Createnetworktopology.

Any query, whatever the query result (dijsktra_result) includes, takes about 50-60 secends.. Even if shortest path includes 1 edge or 2000 edges, it takes 50-60 seconds.

How can i faster the result especially for small query results?

  • Message #1102

    Hello,

    Wow! 50-60 seconds is too much for only 1600000 edges! There are few ways how to make it faster.

    1. Use wrapper functions - they take only small bounding box around the start and end points of your search, which decreases data loading time

    2. Make sure that you have proper indices on important fields (geometry field, source and target ids etc.) and you vacuum your database regulary.

    3. Try to tinker with your PostgreSQL a little bit (play around with memory usage parameters for example).

    4. Use faster server :)

    I hope it helps.

    • Message #1104

      Hello;

      I've chosen 4th :) thanks for your reply.. now takes 6-7 seconds..