From: | Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump makes our system unusable - any way to pg_dump in the middle of the day? (postgres 8.4.4) |
Date: | 2011-02-27 09:25:12 |
Message-ID: | AANLkTi=h5aj8XYDZm9Rhw8N-sr76o3hK3fL6EkgO-W0X@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Our disk service times and % utilization (according to sar -d) while
running pg_dump are low. For example:
01:23:08 AM DEV tps rd_sec/s wr_sec/s avgrq-sz
avgqu-sz await svctm %util
01:23:09 AM sda 1473.00 0.00 98128.00 66.62
0.41 0.28 0.03 3.70
01:23:09 AM sda1 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
01:23:09 AM sda2 1473.00 0.00 98128.00 66.62
0.41 0.28 0.03 3.70
01:23:09 AM sdb 1.00 0.00 16.00 16.00
0.00 3.00 3.00 0.30
01:23:09 AM sdb1 1.00 0.00 16.00 16.00
0.00 3.00 3.00 0.30
01:23:09 AM sdc 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
01:23:09 AM sdd 678.00 161584.00 0.00 238.32
0.34 0.49 0.45 30.20
01:23:09 AM sdd1 678.00 161584.00 0.00 238.32
0.34 0.49 0.45 30.20
01:23:09 AM nodev 12266.00 0.00 98128.00 8.00
4.30 0.35 0.00 3.70
01:23:09 AM nodev 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
On Fri, Feb 25, 2011 at 3:50 PM, Benjamin Smith
<lists(at)benjamindsmith(dot)com> wrote:
> I'd also add: run pg_tune on your server. Made a *dramatic* difference for
> us.
Well, that's interesting. I am going to try that, thanks!!
Aleksey.
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2011-02-27 10:52:57 | Re: database is bigger after dump/restore - why? (60 GB to 109 GB) |
Previous Message | Aleksey Tsalolikhin | 2011-02-27 08:49:48 | Re: database is bigger after dump/restore - why? (60 GB to 109 GB) |