PostgreSQL Unix Socket vs TCP/IP Performance

I just finish a test that compares PostgreSQL speed using Unix socket and TCP/IP connection to localhost with SSL enabled. The test was performed on import on OpenStreetMap PBF file (around 17GB of binary data). The result is that loading the data via TCP/IP connection with SSL enabled was about 17% slower than loading data via Unix socket.

Unix socket:
Processing: Node(1542670k 261.2k/s) Way(146203k 26.07k/s) Relation(1518310 44.75/s)  parse time: 45446s

TCP/IP:
Processing: Node(1542670k 257.1k/s) Way(146203k 18.02k/s) Relation(1518310 38.92/s)  parse time: 53122s

Tags: ,

Running your own OpenStreetMap maps (and more)

This post collects useful links when you want to use OpenStreetMap (OSM), being it using the maps, data services or running your OSM own server. There is a lot of OSM documentation on the net which is both good and bad. Some of the documentation is already obsolete so finding the right documentation might be challenging.

General Links:

Links for using OSM:

Contributing to OSM:

Interesting Android applications:

Tags: