-----BEGIN PGP SIGNED MESSAGE-----
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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (FreeBSD)
-----END PGP SIGNATURE-----