I have a warehouse that has many storage yards. I have an order. It has items list and I have to collect them from storage yards. Storage yards are not equal each other. Their length are different from others. I have CAD drawing of the warehouse. I convert it meaningfully for spatial queries with MapInfo and post it to PostgreSQL.
I use a point to get location of storage yards and connect them each other with lines.
I need to get shortest path between warehouse enter gate and exit gate when I collect the items from storage yards.
Now here is my doubts,
Should I use which version of PostgreSQL and PostGIS?
When I research TSP I see various algorithm exists. Should I use which technique?
How can I compare these technique each other?
Should I import my points and lines to PostgreSQL as x,y coordinate as each one is one column or both are in one column?
What should I give cost for each line? Should it be 1 for every line?