I want to import several city extracts from the bbike website into my postgis database. I use windows on a desktop pc with 16GB RAM and a quadcore processor. The first couple of extracts imported fairly well. I used this command:
osm2pgsql --append -s --database <database>--username <username> <path to pbf>
After around 10 extracts the import looks like it stopped (Speed 0.0k) without any error message or it is extremely slow. When I add the cache flag and set it to 12000 it has now effect.
Looking at pgadmin there still seems to be activity on the db. This is what my pgAdmin panel looks like:
Did anyone experience the same and got a solution? What could be the reason for this?