> Brian Baquiran in the [GENERAL] list recently asked if it was
> possible to
> 'throttle-down' pg_dump so that it did not cause an IO bottleneck when
> copying large tables.
>
> Can anyone see a reason not to pause periodically?
How about a simple renice ? (You mention that CPU goes to 100 % too)
>
> The only problem I have with pausing is that pg_dump runs in a single
> transaction, and I have an aversion to keeping TX's open too
> long, but this
> is born of experience with other databases, and may not be
> relevant to PG.
Probably not an issue with postgres.
Andreas