I have the large roads network (urban walking paths). I'm trying create topology in my database but when query reaches 175 thousands of edges, begins to increase memory usage. In the same time CPU usage is decreasing. After some time, I get an error:
"Connection to the server has been lost."
I read these topics:
pgr_createTopology() 'Connection to the server has been lost'
But the first has not been explained and in the second - I do not know Python.
I tried to upgrade and downgrade PgAdmin Version. Nothing works.
I also tried to simplify the geometry. Unfortunately, it didn't help either.
I use this query:
select pgr_createTopology ('roads', 0.0001, 'geom','id');
PgAdmin Version 4.13 with PostGIS 2.5.2 and pgRouting 2.6.2.
I have 8GB RAM.