[PERFORM] Thanks All!

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

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

2006-08-07 Thread Saranya Sivakumar
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 t

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

2006-08-07 Thread Saranya Sivakumar
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 witho

Re: [PERFORM] 7.3.2 pg_restore very slow

2006-08-07 Thread Saranya Sivakumar
SHMMAX and SHMMIN. Any help/advice would be greatly appreciated.   Thanks, Saranya Richard Huxton 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.> T

Re: [PERFORM] 7.3.2 pg_restore very slow

2006-08-07 Thread Saranya Sivakumar
downtime of only 1 to 1.5 hours. I am going to increase the shared_buffers, sort_mem and disable fysnc as suggested by you, and try the restore process again.   I would appreciate any other suggestions/advice in this regard.   Thanks, Saranya   Richard Huxton wrote: Saranya Sivakumar wrote

[PERFORM] 7.3.2 pg_restore very slow

2006-08-06 Thread Saranya Sivakumar
time using 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] System Requirement

2005-06-14 Thread Saranya Sivakumar
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 over 100 users using the application and we have customers  world

[PERFORM] System Requirement

2005-06-13 Thread Saranya Sivakumar
Hi All, We are looking to upgrade to 8.0 from 7.3.2 on production server. The current production system we are using is 2 x 2.4 Ghz Intel Xeon CPU with HT(4 virtual CPUs) RAM - 1GB HDD - 34GB SCSI - Production DB size: 1