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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] +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 > [email protected] > http://lists.openstreetmap.org/listinfo/tilesathome > >
_______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
