[OSM-dev] OSM Fixer [Sequal]

Shaun McDonald shaun at shaunmcdonald.me.uk
Fri Mar 27 12:24:01 GMT 2009


On 27 Mar 2009, at 12:14, Rolf Bode-Meyer wrote:

> 2009/3/26 Matt Amos <zerebubuth at gmail.com>:
>
>> if we were to convert all the tables to innodb we could add
>> transactions, but this would mean significant API downtime. happy for
>> us, then, that we're rolling out 0.6 Real Soon Now with all that
>> transactional and FK goodness and a bunch of other cool stuff too!
>
> Talking about myisam and innodb all the time triggers my curiosity.
> That's because http://wiki.openstreetmap.org/wiki/Servers/smaug states
> PostgreSQL 8.3 on the new DB server. Is this for the main DB or only
> Mapnik rendering related? Or just a mistake?
>

This is for the main DB server. Part of the 0.6 transition will  
include moving from MySQL to Postgres for the sanity of the database  
admins, and improved data integrity.

Shaun





More information about the dev mailing list