Re: Dumping/Restoring with constraints?

On Wed, Aug 27, 2008 at 8:40 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> Thanks. But there seems to be a tangible slowdown of DB operations
> during the time that pg_dump is running. Perhaps some of my
> postgresql.conf variables are not geared to this. (I vaguely recall
> setting it up so that the wal_buffers or checkpoint_segments needed to
> be set upwards for maintenance tasks).
>
> My question: is it possible to interactively set up these variables so
> that pg_dumpall can work very fast? And behind the scenes, without
> slowing stuff down?

Nope, it's not a software problem, it's a hardware problem.  You're
drive subsystem can only deliver data so fast.  The fix is usually
better hardware.  Big RAID controller and lots of drives.