
> 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

Mon, 7 Aug 2000 15:32:45 +0200 
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: pg_dump & performance degradation