-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
As I understand it, our database/tile server (ptolemy) is higher spec than the equivalent hardware at OSM.org, yet it performs much worse (e.g. at rendering tiles). Is this correct?
If so, has anyone compared the indices on ptolemy's database to OSM's?
If that is not the problem, I would like to test performance without VxVM between the filesystem and the disk. While Vx doesn't hurt performance with MySQL, I noticed during testing that it significantly reduced import performance with Postgres. I believe that was fixed by putting pg_xlog on a separate (non-Vx) disk, but it may still be hurting read performance.
Testing this will require some downtime for conversion; based on the amount of data, I would estimate about 8 hours to copy the data off and back again.
- river.