Re: pg_dump and server responsiveness

"Bryan Murphy" <bryan.murphy@gmail.com> writes:
> When we run pg_dump on our database, our web site becomes completely
> unresponsive. ...
> Does pg_dump create table locks?  It doesn't look like an I/O problem
> as far as I can tell...

Only access-share locks, but that could still be an issue if anything in
your system likes to take exclusive locks.  Have you looked into
pg_locks to see if anything's getting blocked?

pg_dump is entirely capable of causing an unpleasant amount of I/O
load, but that shouldn't result in "complete unresponsiveness",
and anyway your iostat output doesn't look like you're saturated...

            regards, tom lane