Skip site navigation (1) Skip section navigation (2)

Re: vacuumdb -z do a reindex?

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 (view raw or flat)
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





In response to

pgsql-general by date

Next:From: Russell WallaceDate: 2009-11-28 22:34:11
Subject: BUG #5218: Easy strategic feature requests
Previous:From: Irene BargDate: 2009-11-28 22:12:24
Subject: Re: vacuumdb -z do a reindex?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group