From: | "Bryan Murphy" <bryan(dot)murphy(at)gmail(dot)com> |
---|---|
To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump and server responsiveness |
Date: | 2007-12-05 16:10:00 |
Message-ID: | bd8531800712050810v17c0a50al9d880a12aac2487a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
Attachment | Content-Type | Size |
---|---|---|
dbio.txt | text/plain | 1.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-12-05 16:14:21 | Re: pg_dump and server responsiveness |
Previous Message | Bryan Murphy | 2007-12-05 16:05:05 | pg_dump and server responsiveness |