[Tilesathome] ROMAv2 - now in postgres

[Ian Dees]

Flo, if you're interested, I can give you an account on my SVN server for
this code.

Or we could find a spot on the openstreetmap SVN...

On Mon, Sep 8, 2008 at 3:35 PM, Florian Lohoff <flo at rfc822.org> wrote:

>
> Hi,
> i tried around with the postgresql stuff as i like postgres more than
> mysql and made a ROMAv2 for postgres. Its completely different as it
> implements all of the logic in sql and selects data into temp tables
> to be able to stream out nodes, way and relations one after another.
> So memory usage vs disk io is handled in the database.
>
> The postgres variant is much faster when importing the planet. Its
> slower when querier cache hot but faster queried cache cold.
> The difference might be due to the pgsql version returning user names
> and timestamp informations so it adds cpu overhead.
>
> The URL to try with is here:
>
> http://tiles-two.lab.rfc822.org/api/0.5/map?bbox=
>
> The biggest advantage though is that it seems not to have the obscure
> utf-8 bugs i have seen with the mysql. All output i had a look at looked
> clean - no strange ???? tags/values ...
>
> Code is here:
>
> http://tiles-two.lab.rfc822.org/~flo/map-pgsql.cgi<http://tiles-two.lab.rfc822.org/%7Eflo/map-pgsql.cgi>
>
> Differences to the osmosis simple postgres schema is removal of the ways
> bbox as its a cpu time killer and an added btree index on way_id in
> ways. See the osmosis patch i send previously.
>
> BTW: Both ROMAs now have a check for the age of the planet in the db and
> return 503 in case the planet is older than 15 minutes.
>
> Flo
> --
> Florian Lohoff                  flo at rfc822.org             +49-171-2280134
>        Those who would give up a little freedom to get a little
>          security shall soon have neither - Benjamin Franklin
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFIxYyHUaz2rXW+gJcRAjwlAKDfmLOWUn15AmCbulKcfsdQoHbUWgCeOZVv
> Qfr4HoN28xHDm45/vj+O1qk=
> =uWcH
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Tilesathome mailing list
> Tilesathome at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/tilesathome
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20080908/c66297e7/attachment.html>