-----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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (FreeBSD)
iEYEARECAAYFAkzmWEkACgkQIXd7fCuc5vLqAQCguzjEGzMXZTcRfQFKKISsw0hI
8ggAoMDmU+HOp4VPZBIp9SBuWrdY/Ua7
=TpV4
-----END PGP SIGNATURE-----