[PERFORM] System Requirement

Hi All, We are looking to upgrade to 8.0 from 7.3.2 on production server. The currentproduction systemwe are using is 2 x 2.4 Ghz Intel Xeon CPU with HT(4 virtual CPUs) RAM - 1GB HDD - 34GB SCSI - Production DB size:

Re: [PERFORM] System Requirement

Hi, Thanks for the advice on increasing RAM and switching to AMD processors. To tell more about our DB: Our DB is transaction intensive. Interaction to the DB is through a web based application. Typically at any instant there are over100 users using the application andwe have customers

[PERFORM] 7.3.2 pg_restore very slow

7.3.2 version.Thanks, Sincerely, Saranya Sivakumar Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

Re: [PERFORM] 7.3.2 pg_restore very slow

of only 1 to 1.5 hours. I am going to increase the shared_buffers, sort_mem and disable fysnc as suggested by you, andtry the restore process again. I would appreciate any other suggestions/advice in this regard.Thanks, SaranyaRichard Huxton dev@archonet.com wrote: Saranya Sivakumar

Re: [PERFORM] 7.3.2 pg_restore very slow

/advice would be greatly appreciated.Thanks, Saranya Richard Huxton dev@archonet.com wrote: Saranya Sivakumar wrote: Hi All, I am trying to back up a full copy of one of our databases (14G) and restore it on another server. Both databases run 7.3.2 version. Though the restore completed

Re: [NOVICE] [PERFORM] 7.3.2 pg_restore very slow

Hi Richard,Thank you very much for the information. The SHMMAX was set to 33554432, and that's why it failed to start the postmaster. Thanks for the link to the kernel resources article. I guess changing these parameters would require recompiling the kernel. Is there any work around

Re: [NOVICE] [PERFORM] 7.3.2 pg_restore very slow

Hi All,Thanks Richard for the additional link. The information is very useful.The restore completed successfully in 2.5 hours in the new 2GB box, with the same configuration parameters. I think if I can tweak the parameters a little more, I should be able to get it down to the 1 hr down

[PERFORM] Thanks All!

on the community! Thanks, Saranya Sivakumar - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta.