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. > 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. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
