[OSM-dev] Can SQLite3 handle OSM 150G data file?

Kelly Jones kelly.terry.jones at gmail.com
Fri May 15 04:22:00 BST 2009

Thanks to everyone who replied.

OK, loading all the nodes for OSM doesn't take much time, but INDEXing
the fields takes forever (days).

The first time I tried this, I pre-created the indexes before loading
the data. That's why the load took so long.

This time, I loaded the data first (fairly quick) and then created the
indexes. It's now been several days and the indexes are still being


We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

On 4/27/09, Kelly Jones <kelly.terry.jones at gmail.com> wrote:
> I've seen many posts saying that SQLite2 can't handle OpenStreetMap's
> large planet.osm data file:
> http://planet.openstreetmap.org/planet-090421.osm.bz2
> which is 5.4G bzip2 compressed, about 150G uncompressed.
> Can SQLite3 handle this? Has anyone tried?
> I tried to do this myself, but I'm on a slow machine and it's taking
> too long (several days so far). If someone's done this, can I get a copy?

More information about the dev mailing list