[OSM-dev] OSM Fixer [Sequal]

[Matt Amos]

On Fri, Mar 27, 2009 at 3:01 PM, Stefan de Konink <stefan at konink.de> wrote:
> Shaun McDonald wrote:
>> 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.
>
> ...and still 0 on a real benchmark.

if you'd like to help out it would be great if you could do some benchmarking!

cheers,

matt