tags: tuning, PostgreSQL, import

Action executed in 0.000

Each Tag

tuning, PostgreSQL, import

Common tags - number of posts

OSM (8), planet (8), osmosis (5), up-to-date (5), osm2pgsql (4), render (4), tile (4), XAPI (3), pnorman (3), pgsnapshot (3), mapnik (3), jxapi (3), regex (2), index (2), database (2), disk (1), aggregation (1), PHP (1), Python (1), ERD (1), script (1), beer (1), query (1), citext (1), text (1), case (1), GIS (1), Areca (1), TIGER (1), map (1), Linux (1), devops (1), PostGIS (1), femenism (1), RAID (1), programming (1), library (1), procedural language (1), Akonadi (1),

4 way join

OSM, PostgreSQL, import, tuning, PostgreSQL, import, planet, tuning

5 way join

OSM, PostgreSQL, import, planet, tuning

Sub groups 2

Sub groups 1

PostgreSQL, index, regex (2), PostgreSQL (2), Akonadi, ERD, PostgreSQL, database (1), PHP, PostgreSQL, procedural language (1), GIS, PostgreSQL, library (1), OSM, import, osm2pgsql, osmosis, planet, script, up-to-date (1), Areca, Linux, PostgreSQL, RAID, disk (1), PostgreSQL, aggregation, query (1), OSM, import, osmosis, planet, render, tile, up-to-date (1), PostgreSQL, case, citext, text (1), PostgreSQL, Python, devops, femenism (1), PostGIS, PostgreSQL, TIGER, beer, database, map, programming (1)

●●●●●○○○

Build your own OpenStreetMap Server - Ubuntu 10.04 Lucid Lynx | weait.com

SUNY Buffalo campus as seen on OpenStreetMap.org in March of 2009

Build your own OpenStreetMap server. Build your own what?

OpenStreetMap is the editable World map of everything. It is the Wikipedia of maps. It is to other on-line maps as Wikipedia is to Britannica. And it is awesome in every possible way.

The current version of this article is based on Ubuntu 10.04 Lucid Lynx. Lucid will be released on 29 April 2010 and be in beta until then. Operating systems in beta are not suitable for production use.

url: http://weait.com/content/build-your-own-openstreetmap-server-lucid

type: article, format: blog

●●●●●○○○

Loading a Pgsnapshot Schema With a Planet: Take 2 - Paul's Blog

Awhile back I ran my own jxapi server, running with postgresql 8.4. I recently upgraded my server, and in the process I decided to re-import the database into postgresql 9.1.

url: http://www.paulnorman.ca/blog/2011/11/loading-a-pgsnapshot-schema-with-a-planet-take-2/

type: article, format: blog