[pgsql-jp: 33941] VACUUMが止まる？

[Masahiro Ishida]

$B=i$a$FEj9F$5$;$FD:$-$^$9!#(B
$B$465<x$NDx$h$m$7$/$*4j$$CW$7$^$9!#(B

$B$O$8$a$K>l0c$$$J<ALd$+$b$7$l$J$$$3$H$r$4MF<O2<$5$$!#(B

VACUUM$B=hM}$r<B9T$7$F$*$j$^$9$,=hM}$,ESCf$G;_$^$C$F$$$k$h$&$K8+$($^$9!#(B
top$B%3%^%s%I$G3NG'$9$k$H%W%m%;%9$N>uBV$O(BSLEEP$B$G(BCPU$B;HMQN($O(B0%$B$N$^$^$G$9!#(B
$B;~4V$,$+$+$k$N$OM=A[$7$F$*$j$^$9$,B>$K(BCPU$B;~4V$r>CHq$7$F$$$k%W%m%;%9$O$J(B
$B$$$?$a(B
$B2?8N$3$N$h$&$J>uBV$K5?Ld$K;W$C$F$*$j$^$9!#(B
OS$BB&$NLdBj$G$7$g$&$+!)(B
$B2?$+2r7h$N;e8}$K$J$k$3$H$r$465<xD:$1$^$9$H9,$$$G$9!#(B

$B4D6-(B
$B!!(BOS$B!!(BSolaris8
$B!!(BPostgreSQL$B!!(B7.3.4

$B<B9T%3%^%s%I(B
$B!!(Bnice --10 vacuumdb -e -f -v$B!!(B -U$B!!(B<UID> <dbname>

$B%^%7%s>u67(B
load averages:  0.01,  0.01,  0.01
81 processes:  79 sleeping, 1 stopped, 1 on cpu
CPU states: 99.6% idle,  0.0% user,  0.4% kernel,  0.0% iowait,  0.0%
swap
Memory: 512M real, 287M free, 157M swap in use, 739M swap free