On Fri, Mar 27, 2009 at 3:01 PM, Stefan de Konink <[email protected]> wrote: > Shaun McDonald wrote: >> On 27 Mar 2009, at 12:14, Rolf Bode-Meyer wrote: >> >>> 2009/3/26 Matt Amos <[email protected]>: >>> >>>> 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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
