[pgrouting-users] RAM usage and pgrouting performance

[Tao Romera Martinez]

Dear all,

I have tried to put the table containing the road network as well as
all the indices related in the RAM, but have not appreciated the
slightest difference in performance when running shortest_dijkstra.
Am I doing something wrong? Has anyone tried to do the same with the
same results?

I was expecting a big speed improvement, since most of the execution
time of shortest_dijkstra goes in fetching the road data from the
table, located in the hard disk.
The way I proceeded to move the table and its indices to the RAM was
to mount a directory of the file system into the RAM and then change
the tablespaces to this directory:

* Create directory and mount
mkdir /DB_data/ram_space
sudo mount -t tmpfs -o size=3000M tmpfs /DB_data/ram_space

* Move tablespaces
CREATE TABLESPACE ram_space LOCATION '/DB_data/ram_space';
ALTER TABLE my_table SET TABLESPACE ram_space;
ALTER INDEX my_index SET TABLESPACE ram_space;

Thanks for any feedback,

Tao