pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
postgresql basic info 3+ messages / 3 participants [nested] [flat]
* postgresql basic info @ 2010-07-27 10:37 Lazarin Toni <Toni.Lazarin@kapsch.net> 2010-07-27 20:34 ` Re: postgresql basic info Craig James <craig_james@emolecules.com> 0 siblings, 1 reply; 3+ messages in thread From: Lazarin Toni @ 2010-07-27 10:37 UTC (permalink / raw) To: pgsql-admin Hello, I am Oracle DBA and i will be maybe work on a project where postgresql database will be used. So i would be greatful if you could please advise me on the folowing : * Estimated time for postgresql latest RDBMS software instalation and configuration (does it takes longer on windows or on linux) * Are there any prefered OS, like windows or linux etc ... ? * Estimated time for import of 50gb of data from older postgres to the newly instaled postgres? Thanks. The information contained in this e-mail message is privileged and confidential and is for the exclusive use of the addressee. The person who receives this message and who is not the addressee, one of his employees or an agent entitled to hand it over to the addressee, is informed that he may not use, disclose or reproduce the contents thereof, and is kindly asked to notify the sender and delete the e-mail immediately. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql basic info 2010-07-27 10:37 postgresql basic info Lazarin Toni <Toni.Lazarin@kapsch.net> @ 2010-07-27 20:34 ` Craig James <craig_james@emolecules.com> 0 siblings, 0 replies; 3+ messages in thread From: Craig James @ 2010-07-27 20:34 UTC (permalink / raw) To: pgsql-admin On 7/27/10 3:37 AM, Lazarin Toni wrote: > I am Oracle DBA and i will be maybe work on a project where postgresql > database will be used. > > So i would be greatful if you could please advise me on the folowing : > > · Estimated time for postgresql latest RDBMS software instalation and > configuration (does it takes longer on windows or on linux) Most of your time will be spent wondering what you've overlooked, thinking it couldn't possibly be that simple. Seriously, if you know Linux or BSD admin, you can download it from source, compile and have a working database in about 30 minutes. If your distro has Postgres, then your installation time is zero. You'll spend some time tuning your configuration file for your particular needs. The postgres-performance mailing is a good place to ask this question. The most important considerations are common to both Postgres and Oracle. That is, what kind of hardware do you have, and is it sufficient to your workload? CPUs, disks, memory, RAID config, and so on. That's also a question for the postgres-performance mailing list. > · Are there any prefered OS, like windows or linux etc ... ? BSD or Linux. Windows is considered a second-tier platform for Postgres. > · Estimated time for import of 50gb of data from older postgres to the > newly instaled postgres? Depends a lot on your hardware, and also on the nature of the data (lots of indexes will add time). It also depends how you do it. pg_dump/pg_restore are pretty fast. This would probably take a few hours on a reasonable mid-sized server, for example, with an 8-disk RAID 10 array with a battery-backed RAID controller. Craig ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql basic info @ 2010-07-27 20:49 Kevin Grittner <Kevin.Grittner@wicourts.gov> 0 siblings, 0 replies; 3+ messages in thread From: Kevin Grittner @ 2010-07-27 20:49 UTC (permalink / raw) To: Toni.Lazarin@kapsch.net; pgsql-admin Lazarin Toni <Toni.Lazarin@kapsch.net> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-07-27 20:49 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-07-27 10:37 postgresql basic info Lazarin Toni <Toni.Lazarin@kapsch.net> 2010-07-27 20:34 ` Craig James <craig_james@emolecules.com> 2010-07-27 20:49 Re: postgresql basic info Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox