Skip to content

Instantly share code, notes, and snippets.

@pnorman
Last active December 19, 2015 17:39
Show Gist options
  • Save pnorman/5992905 to your computer and use it in GitHub Desktop.
Save pnorman/5992905 to your computer and use it in GitHub Desktop.
test done cold hot mem
linestring, apidb, extract 33m28.449s 28m55.834s 7G
way_nodes, pgsnapshot, extract 15m13.645s 10m23.546s 6G
linestring, pgsnapshot, extract 14m22.915s 10m23.181s 4G
parent_ways, pgsnapshot, extract* 14m39.141s 10m12.592s 5G
way_nodes, pgsnapshot, full 37m2.924s 10m10.498s 11G
linestring, pgsnapshot, full 27m40.750s 10m25.437s 8.5G
* Different DB, but same data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment