-----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 databases that large so I don't know if that's > good or bad.. others on the list will be able to offer advice/suggestions. RAM certainly helps, but pg_dump is single-threaded, and, by definition, backing up and restoring 60GB of data is *extremely* IO constrained. So, - - What OS? - - What version of PG? - - what kind of disk system does the DB live on? - - How many controllers? - - What kind of tape drive? - - Is it on it's own SCSI controller? - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFQH10S9HxQb37XmcRAhFpAKCeBZbTPQW8mhY8EgG26R7OgpgrlQCeMAek KmPbaWmLx+N+kYQvHNOgiL0= =YsM3 -----END PGP SIGNATURE-----
