[Tilesathome] Two new ROMA...

[Justin]

I run the frdrmd/hades box-- mat runs the load balancer along with his two
romas.  I ran into similar issues such as yours with speeds-- you need to
create two more indexes on nodes_ways;
create index idx_ways_big on way_nodes using btree (way_id);
create index idx_nodes_big on way_nodes using btree (node_id);

(those usually take anywhere from 10-120 minutes to process)

As far as specs go, my roma is a really hacked together system; Core 2 Duo
E6400, 4GB ram, SW Raid0 across 7 random hard drives I had in the basement.

Phpsysinfo;
http://frdrmd.roma.osm.phyrefile.com/phpsysinfo/
And pretty munin graphs;
http://frdrmd.roma.osm.phyrefile.com/munin/

Let me know if the problem persists after adding the indexes.

-Justin / Quiky

On Tue, Dec 2, 2008 at 7:49 PM, Milenko <milenko at king-nerd.com> wrote:

> Hi all,
>
> First I wanted to say thanks to Mathieu providing these two servers for
> client use.  I'm sure they'll be a big help once they're in general use in
> the stable client.
>
> I have been attempting to bring my own ROMA server online as yet another
> ROMA option (YAROMAO??), but I'm not seeing anything close to the same
> performance as either of these two servers.  I was wondering if you'd be
> willing to share the specs of these servers and/or tweaks and tuning you
> used to speed up postgresql so that I could compare with my server.
>
> For the record, my server is a 2x 3.0 Ghz Xeon with 8GB RAM and 4x 150GB
> Velociraptor drives in RAID0 on an LSI MegaRAID 8344ELP controller.
> Bonnie++ shows block reads at 426MB/s and over 700 seeks/s.
>
> While fetching bbox 37.221680,11.594560,37.397461,11.709906 I get data in
> sub-30 seconds from your two servers while mine takes over 130 seconds.
>
> I'll be the first to admit I'm not a pgsql admin, so there hasn't been much
> tweaking done to the config on my server.
>
> Any help would be greatly appreciated.
>
> -Jeremy
>
>
> -----Original Message-----
> From: tilesathome-bounces at openstreetmap.org
> [mailto:tilesathome-bounces at openstreetmap.org] On Behalf Of Mathieu Arnold
> Sent: Monday, November 24, 2008 9:22 AM
> To: TilesAtHome
> Subject: [Tilesathome] Two new ROMA...
>
> Hi,
>
> I'm pleased to announce that there are now three ROMA servers, the new two
> are located at frdrmd.roma.osm.phyrefile.com, api1.osm.absolight.net.
>
> There may be some rough edges, but both have been serving a few clients for
> some time now.
>
> There also is a haproxy (which may still need tuning, but, hey, can't know
> that untill more people use it.) located on the last server, the simplest
> way
> to use it would be to put :
>
> API_ROMA = http://api1.osm.absolight.net:8080/api/%v/map?bbox=%b
>
> in your tilesAtHome.conf.
>
> If you don't want to change that old ROMA url, you could do :
>
> APIServers = ROMA2,API,ROMA,XAPI
> API_ROMA2 = http://api1.osm.absolight.net:8080/api/%v/map?bbox=%b
>
> which would let you keep a backup in case the haproxy goes down and the
> main
> API and the XAPI goes down too :-)
>
> --
> Mathieu Arnold
>
> _______________________________________________
> Tilesathome mailing list
> Tilesathome at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/tilesathome
>
>
>
> _______________________________________________
> 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/20081202/5035f2ab/attachment.html>