Re: pg_dump and server responsiveness

Sorry about the formatting, here's the dump as a text file.

Thanks,
Bryan

On Dec 5, 2007 10:05 AM, Bryan Murphy <bryan(dot)murphy(at)gmail(dot)com> wrote:
> When we run pg_dump on our database, our web site becomes completely
> unresponsive. I thought pg_dump was runnable while the database was
> still being actively used? Anyway, I'm not entirely sure why, but
> here's what I'm seeing.
>
> pg_dump -v database_name | gzip > output_file
> 25% to 50% CPU usage (4 proc machine)
> Entire database is cached in memory, so the only I/O is what's being
> dumped to the output file
> Web site becomes unresponsive almost immediately