Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-27 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/27/06 02:26, Coder At Heart wrote: > Hi! > > Thanks so much for the responses. The system configuration is something > like > this- That's a start... > Linux, Presumably a 2.6 kernel? Which, and which distro version? PG 8.1, OK ext3, OK

Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-27 Thread Coder At Heart
Hi!   Thanks so much for the responses. The system configuration is something like this-   Linux, PG 8.1, ext3, RAID 1 setup with two controllers   The machine has 4 processors with 32 Gig of RAM.   Thanks!Shivkumar   On 10/27/06, Stefan Kaltenbrunner <[EMAIL PROTECTED]> wrote: Ron Johnson wrote:>

Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-26 Thread Stefan Kaltenbrunner
Ron Johnson wrote: > On 10/26/06 01:20, Chris wrote: >>> Coder At Heart wrote: Hi! Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 G RAM machine for a 60GB database. >>> Please always cc the mailing list. >>> >>> I've never played with databases that lar

Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-26 Thread Robert Treat
On Thursday 26 October 2006 02:20, Chris wrote: > Coder At Heart wrote: > > Hi! > > > > Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 G > > RAM machine for a 60GB database. > > Please always cc the mailing list. > > I've never played with databases that large so I don't kno

Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/26/06 01:20, Chris wrote: > Coder At Heart wrote: >> Hi! >> >> Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 >> G RAM machine for a 60GB database. > > Please always cc the mailing list. > > I've never played with data

Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-25 Thread Chris
Coder At Heart wrote: Hi! Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 G RAM machine for a 60GB database. Please always cc the mailing list. I've never played with databases that large so I don't know if that's good or bad.. others on the list will be able to offe

Re: [GENERAL] Reducing pg_dump & pg_restore times

2006-10-25 Thread Chris
C.M. Shivkumar wrote: Hello all! I have databases of sizes ranging from 30-60GB that have to be backed-up and restored. I want to reduce the pg_dump and pg_restore times for the same. Can someone throw some light on how to go about it. I have tried tweaking the postgresql.conf properties. Tho

[GENERAL] Reducing pg_dump & pg_restore times

2006-10-25 Thread C.M. Shivkumar
Hello all!I have databases of sizes ranging from 30-60GB that have to be backed-up and restored. I want to reduce the pg_dump and pg_restore times for the same. Can someone throw some light on how to go about it. I have tried tweaking the postgresql.conf properties. Though, I am not sure what each