Re: Practical maximums (was Re: PostgreSQL theoretical

Ron Johnson wrote:

> This is where a multi-threaded pg_tapedump would be more effective,
> since it would be able to, for example, have 4 threads reading
> (different parts of) the database and writing to 4 separate tape drives.

It will be difficult to have a consistent dump though.  You can't do
that with separate transactions.  (And you can't have multiple
simultaneous readers without separate transactions.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support