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
Views: Raw Message | Whole Thread | 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

In response to

Browse pgsql-general by date

  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?