Right now our 8.1.4 is running without any compiler options. Any possible problem if i will compile the 8.1.8 with CLAGS -O2 -march=Opteron --> will the datafiles of the 8.1.4 non optimized postgres make any problems?
Thanks a lot,
Thomas
Peter Eisentraut schrieb:
Thomas Papke wrote:
1. i am running a large postgres 8.1.4 database in production. What
is a good and safe way for an minor update to 8.1.8 (less downdown
and possible jump back option)?
Using binary packages, install the new one over the old one, and if you
don't like it, install the old one over the new one.
How riskful is an minor update for the data files?
Not riskful.
2. i am using two dualcore opterons with 8GB memory - if i am using
the CFLAGS="-O2" option for compile optimization --> is there any
real performance boost?
I don't think anyone has ever seriously considered building with
anything less than -O2 for anything but debugging purposes or coping
with buggy compilers on rare architectures. In other words, there
isn't any good reason not to do it.