-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peter Eisentraut wrote: > Ron Johnson wrote: >> I think I've read that there are multi-hundred GB PostgreSQL >> databases. >> >> Since pg_dump is single-threaded, how long does it take to back up >> such a database? > > The evasive answer is that you probably don't run regular full pg_dump > on such databases.
Hmmm. >> Are there any plans of making a multi-threaded, or even >> multi-process pg_dump? > > What do you hope to accomplish by that? pg_dump is not CPU bound. Write to multiple tape drives at the same time, thereby reducing the total wall time of the backup process. - -- 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.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEzhl2S9HxQb37XmcRArRoAKDiVOicD7giL2lWF5zMa9qQanwXjQCfdY6r 0eswQQ5nJb8l5Mbp+ok0ZRs= =MWSM -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
