-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
I am planning to replace Sun's PostgreSQL on ptolemy with our own Postgres package. If we stay with 8.3, this will only involve about 10 minutes downtime for the upgrade, and will be transparent to users. 8.3 is supported until February 2013, so there is no pressing need to upgrade.
However, it might make sense to upgrade to a more recent version at the same time; either 8.4 or 9.0. This will require a dump and reload of all databases, so it will take a while to complete. As far as I know, there should be no (or very few) changes required to tools using the database.
I don't have a strong opinion either way, although I think it makes sense to upgrade regularly rather than stay on the same version forever. Before I make a decision, it would be nice to know what people actually using the database think.
- river.
Hi River
Am 30.09.2010 09:22, schrieb River Tarnell:
However, it might make sense to upgrade to a more recent version at the same time; either 8.4 or 9.0. This will require a dump and reload of all databases, so it will take a while to complete. As far as I know, there should be no (or very few) changes required to tools using the database.
There are known performance issues with the diff update process on 8.4 [1]. There has been some talk [2] about 9.0 but no real experience with it.
I don't have a strong opinion either way, although I think it makes sense to upgrade regularly rather than stay on the same version forever. Before I make a decision, it would be nice to know what people actually using the database think.
I'd like to give 9.0 a try but we'd need a way run it in parallel to 8.3 (maybe on another server) to do some benchmarking between them before we make a decision for the one or the other.
Peter
[1] http://www.mail-archive.com/dev@openstreetmap.org/msg11474.html [2] http://www.mail-archive.com/dev@openstreetmap.org/msg12707.html
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Peter Körner:
I'd like to give 9.0 a try but we'd need a way run it in parallel to 8.3 (maybe on another server) to do some benchmarking between them before we make a decision for the one or the other.
It's trivial to set up another instance (or two) on ptolemy if you want to test performance. (Of course, it would need to be when the server was otherwise idle to give meaningful results...) There is plenty of space in the diskgroup to allow a full database import during the test.
- river.
Am 01.10.2010 07:29, schrieb River Tarnell:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Peter Körner:
I'd like to give 9.0 a try but we'd need a way run it in parallel to 8.3 (maybe on another server) to do some benchmarking between them before we make a decision for the one or the other.
It's trivial to set up another instance (or two) on ptolemy if you want to test performance. (Of course, it would need to be when the server was otherwise idle to give meaningful results...) There is plenty of space in the diskgroup to allow a full database import during the test.
I'd love to give it a try but I'm afraid I won't have time for this during the next weeks, so best would be to stay with 8.3 and postpone the 9.0 tests.
Peter