Subject: Overpass API developpement
List archive
- From: Roland Olbricht <>
- To:
- Subject: Re: [overpass] Performance question
- Date: Mon, 21 Nov 2016 06:09:42 +0100
Hi,
Assume a server with many CPU's (6) and many RAM (24 GB). Is there any
thumb rule of how many times faster Overpass queries would be with
Overpass db running totally on a SSD compared with a classic fast hard
disk?
Usually, with a SSD the server gets CPU bound. With a disk, it is usually disk bound.
Does OP profit from more RAM and CPU's?
Please look into your server load. The individual queries are single thread. Hence, it depends on how much queries you would like to run in parallel.
More RAM means more data in the cache. This is highly relevant with a harddisk and probably less relevant with an SSD. I usually had 32 GB machines since the last two or three, and this was enough to let the SSDs stay less than busy, despite 8 CPU cores.
Best regards,
Roland
- Re: [overpass] Setup question, (continued)
- Re: [overpass] Setup question, Zecke, 11/06/2016
- Re: [overpass] Setup question, mmd, 11/06/2016
- Re: [overpass] Setup question, Zecke, 11/06/2016
- [overpass] apply_osc_to_db.sh transactions, Zecke, 11/06/2016
- Re: [overpass] apply_osc_to_db.sh transactions, Zecke, 11/20/2016
- Re: [overpass] apply_osc_to_db.sh transactions, Roland Olbricht, 11/21/2016
- Re: [overpass] apply_osc_to_db.sh transactions, mmd, 11/21/2016
- Re: [overpass] apply_osc_to_db.sh transactions, Roland Olbricht, 11/21/2016
- Re: [overpass] apply_osc_to_db.sh transactions, Zecke, 11/21/2016
- Re: [overpass] Setup question, Zecke, 11/06/2016
- Re: [overpass] Setup question, mmd, 11/06/2016
- [overpass] Performance question, Zecke, 11/20/2016
- Re: [overpass] Performance question, Roland Olbricht, 11/21/2016
- Re: [overpass] Performance question, Zecke, 11/21/2016
- Re: [overpass] Performance question, sly (sylvain letuffe), 11/21/2016
- Re: [overpass] Performance question, Zecke, 11/21/2016
- Re: [overpass] Setup question, Zecke, 11/06/2016
- Re: [overpass] Setup question, Zecke, 11/06/2016
- Re: [overpass] Setup question, mmd, 11/07/2016
- Re: [overpass] Setup question, Zecke, 11/07/2016
Archive powered by MHonArc 2.6.18.