Lazarin Toni <Toni.Lazarin@xxxxxxxxxx> wrote: > * Estimated time for postgresql latest RDBMS software instalation > and configuration (does it takes longer on windows or on linux) That depends. On a kubuntu system which didn't have PostgreSQL installed, I typed: sudo apt-get install postgresql I had a running cluster in about 50 seconds. On the other hand, when I'm going to install a new major release for our production system, I read up on it, download source, build the core product and our home-grown extensions, and test that everything seems to be working OK. Just the builds and basic tests can take an hour. At least half that is because of our home-grown extensions, though. The study and the tests of our applications is very dependent on the specific changes in the new release. > * Are there any prefered OS, like windows or linux etc ... ? I think the best benchmarks I've seen have been on FreeBSD, although I think Linux is more popular. I would stay away from Windows. It seems as though AIX and Solaris tend to have more build issues with special packages than some. > * Estimated time for import of 50gb of data from older postgres > to the newly instaled postgres? That's going to depend on the hardware, line speed (if across the wire), OS, configuration, etc. Ballpark, for our databases and hardware a 50GB pg_dump | psql load (the normal route for major version upgrade) would take 30 to 40 minutes. We use a different configuration for such a conversion or bulk load, and then reconfigure for production; this allows us to turn off fsync and full page writes for the load, which would not be safe for normal use. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
