[OSM-talk] Server slowness

[Frederik Ramm]

Hi,

Richard Fairhurst <richard at systemeD.net> wrote:
> Most of the OSM data is available (planet.osm), as is all of the  
> source. Many OSM developers are busy with other parts of the project  
> at the moment, so if you can provide some benchmarks to show that OSM  
> really does run faster on a PostGIS setup, and show what changes you  
> made to achieve this, we'd be all ears.

It would be great if one of those with access to the log files could 
post a quick statistical overview about what kind of queries the
server has to deal with and how frequent.

I am not a MySQL or PostGIS or other database guru myself but I guess
that those who think they have a great idea, a new indexing scheme or
simply a better tool might want to know what kind of load is put on
the server so that they can devise near-reality test cases.

One would probably need to know what the most frequent types of read
and write requests are and what peak loads to expect.

Or perhaps it is more sensible to analyse this on the API layer
instead of the SQL layer? 

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00.09' E008°23.33'