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
