[OSM-dev] How do I build the latest db schema?

[Martijn van Oosterhout]

On 7/6/07, Brett Henderson <brett at bretth.com> wrote:
> It is able to populate a MySQL database from scratch.  A Postgres DB
> would require the creation of a new writer task.  To improve speed, I'm
> using MySQL specific things like multi-record inserts.  Postgres will
> require smart use of transactions to obtain good speed which aren't
> being used currently.

Recent versions of postgres support multi-value inserts, but the
fastest way remains COPY which will let you load the entire table,
streaming, in a single SQL command.

> All versions are available at:
> http://www.bretth.com/osmosis/

If I get some time I'll have a look at the postgres stuff.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/