[OSM-talk] Databases?

[Jan-Benedict Glaw]

On Thu, 2008-10-16 02:53:46 +1200, Joseph Gentle <josephg at gmail.com> wrote:
> So how good is postgis? Does anyone know if its performant enough for
> real-time map rendering? Can it do level-of-detail stuff ("fetch all
> data in europe with at least city level significance")?

Current versions of gpsdrive (http://www.gpsdrive.de/) and gpsdisplay
(http://lug-owl.de/~jbglaw/gpsdisplay.git) will render their maps
directly off a PostGIS database.

On my laptop, rendering a map in a zoom level useable for in-city
driving will take about 400ms, including parsing of the osm.xml file
and fetching the data from a (possibly almost-hot) PostgreSQL page
cache.

Larger maps, covering half of Germany, will need between about 60 and
250 seconds.

MfG, JBG

-- 
      Jan-Benedict Glaw      jbglaw at lug-owl.de              +49-172-7608481
Signature of:          GDB has a 'break' feature; why doesn't it have 'fix' too?
the second  :
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20081015/b73576fc/attachment.pgp>