Re: vacuumdb -z do a reindex? - Mailing list pgsql-general

From John R Pierce
Subject Re: vacuumdb -z do a reindex?
Date
Msg-id 4B11A1C1.7040205@hogranch.com
Whole thread Raw
In response to Re: vacuumdb -z do a reindex?  (Irene Barg <ibarg@noao.edu>)
List 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





pgsql-general by date:

Previous
From: Irene Barg
Date:
Subject: Re: vacuumdb -z do a reindex?
Next
From: Eduardo Piombino
Date:
Subject: Re: Date with time zone