[pgsql-jp: 36110] Re: マシンのパフォーマンスが極端に悪化

[Kiyoshi Mizuno]

$B?eLn$G$9!#(B

> -----Original Message-----
> $B-!%^%7%s$N%G%#%9%/%"%/%;%9%i%s%W$,$D$-$C$Q$J$7!#(B
> $B-"%m%0%$%s8e%W%m%s%W%H$,La$C$F$/$k$^$G#3J,$0$i$$$+$+$k!#(B
> $B-#$=$NB>%3%^%s%I<B9T$b6KC<$KCY$$!#(B
> $B-$(B/proc/meminfo$B$r(Bcat$B$7$?$H$3$m(Btotal:1320001536$B!"(Bused:1309925376$B$H%a%b%j$rKX$I?)$C$F$7$^$C$F$$(B
> $B$k!#(B
> $B-%(Btop$B%3%^%s%I7k2L$r$_$k$H(Bpostmaster$B$N%W%m%;%9$,#2$D>eIt$KI=<($5$l(B50$B!A(B70%$BDx(BCPU$B$rMxMQ$7$F$$$k!#(B

$B!V%G%#%9%/%"%/%;%9%i%s%W$,$D$-$C$Q$J$7!W(B
$B$H$$$&;v$J$N$G!"$^$:$O%G%#%9%/4X78$r$"$?$j$^$7$g$&!#(B
$B;d$,2DG=@-$H$7$F;W$$$D$$$?$N$O(B
$B!&%O!<%IE*$K(BREAD$B!?(BWRITE$B%(%i!<$,IQH/$7%j%H%i%$$7$F$$$k(B
$B!!"*B((BDISK$B8r49$H8@$$$?$$$,!"(BHDD$B$G$J$/%^%6!<%\!<%IB&$N%3%s%H%m!<%i$,(B
$B!!!!$$$+$l$F$$$k$H$$$&2DG=@-$b$"$j$^$9!#%1!<%V%k$,860x$N$3$H$b!#(B
$B!&%U%!%$%k%7%9%F%`$K%=%U%HE*$J%(%i!<$,H/@8$7$F$$$k!J#f#s#c#k$7$F$/$@$5$$!K(B
$B!&(BDISK$B$N6u$-$,$J$$!J#d#f$7$F$/$@$5$$!K(B
$B!&(BVACUUM$B$,$:$C$H9T$o$l$F$$$J$/$F%G!<%?%U%!%$%k$,$G$+$/$J$C$?(B
$B!!!J(Bcron$B$G(Bvacuum$B$9$k ＠ _Dj$K$7$?$,!"(Bcron$B%9%/%j%W%H$K<B9TB0 ＠ -$r(B
$B!!IU$1K:$l$F<B$O(Bvacuum$B$7$F$$$J$+$C$?$H$$$&;v$,$"$j$^$7$?!#!K(B
$B!&@_Dj$r%_%9$C$F(BPostgreSQL$B$K%a%b%j$rBg$-$/3d$jEv$F$9$.$?(B
$B$H$$$&$/$i$$$G$9!#(B