Re: Reducing pg_dump & pg_restore times

-----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-----