| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: vacuumdb -z do a reindex? |
| Date: | 2009-11-28 22:18:41 |
| Message-ID: | 4B11A1C1.7040205@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Irene Barg wrote:
>
> avg-cpu: %user %nice %system %iowait %steal %idle
> 0.00 0.00 0.01 0.00 0.00 99.99
>
> Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz
> avgqu-sz await svctm %util
> sda 0.00 0.60 0.00 1.00 0.00 12.80 12.80
> 0.00 0.00 0.00 0.00
> sda1 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 0.00 0.00 0.00 0.00
> sda2 0.00 0.60 0.00 1.00 0.00 12.80 12.80
> 0.00 0.00 0.00 0.00
> sda3 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 0.00 0.00 0.00 0.00
> sda4 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 0.00 0.00 0.00 0.00
> sda5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 0.00 0.00 0.00 0.00
> sda6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 0.00 0.00 0.00 0.00
that appears to be a system thats close to totally idle. what volume
is sda2 ? It had an average of 1 write of 12.8 sectors/second thats
about 6.5 kbyte/sec, whihc easily could be .bash_history or syslog or
other background activity
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russell Wallace | 2009-11-28 22:34:11 | BUG #5218: Easy strategic feature requests |
| Previous Message | Irene Barg | 2009-11-28 22:12:24 | Re: vacuumdb -z do a reindex? |