[Maps-l] ptolemy performance

[River Tarnell]

-----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-----