Thanks for the tip - that certainly did the trick. I ran a couple requests through and got sub-10 seconds on each request.
That's a tip that should be documented on the wiki. :) Thanks again, Jeremy ----- Original Message ----- From: Justin To: Milenko Cc: TilesAtHome Sent: Tuesday, December 02, 2008 8:15 PM Subject: Re: [Tilesathome] Two new ROMA... 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] http://lists.openstreetmap.org/listinfo/tilesathome _______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
_______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
