Re: Vacuum Problems

How I do to see my I/O subsystem? vmstat? If so, follow:[root(at)postgres ~]#
vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free buff cache si so bi bo in cs us sy id
wa st
0 13 127728 58020 19072 1332076 3 2 3 1 1 7 11 3 52
33 0
1 13 127728 56488 19156 1332456 0 0 644 168 2534 1528 5 3 48
44 0
2 10 127728 55644 19216 1333136 0 0 700 640 1989 1723 5 5 46
44 0
0 12 127728 53252 19268 1334640 0 0 864 796 2351 1833 5 4 47
43 0
0 13 127728 53016 19296 1334208 0 0 2040 452 2277 2126 6 5 40
49 0
0 11 127728 52944 19224 1331508 0 0 1208 484 2306 1421 5 3 21
71 0
1 15 127728 56628 19016 1331012 0 0 1620 944 2410 2499 7 5 24
64 0
1 12 127728 55360 19032 1332500 0 0 1040 592 2423 2074 6 5 7
82 0
2 9 127728 54592 19068 1333344 4 0 1392 604 2695 2431 8 8 22
63 0
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free buff cache si so bi bo in cs us sy id
wa st
4 8 127728 54632 19084 1334676 0 0 892 1164 2530 2147 5 4 53
38 0
0 10 127728 53256 19064 1333148 0 0 920 208 3119 2765 11 5 15
68 0
0 10 127728 54296 18856 1331404 0 0 756 572 2419 1412 7 3 40
50 0
1 9 127728 57544 18872 1332012 0 0 816 800 2577 2390 8 7 27
59 0

The Hard Drive is a SATA-II 150 Gb, dedicate to postgres service.

2008/12/8 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>

> On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
> <rafael(dot)domiciano(at)gmail(dot)com> wrote:
> > Hello guys,
> > I tried to modify my vacuum routine, and started to only run vacuum
> verbose
> > analyze diary followed by a reindex weekly.
> > But I still having problems in my database. The uptime database is hard
> to
> > stay below 10.
> > I'm thinking that my hardware is not more good as it was sometime ago.
> > The machine is a: 2 x Intel Xeon Dual-Core 2.3 GHz, 2 Gb RAM. The load on
> > machine is about at 10000 transactions / m
> > Maybe I need more RAM memory?
>
> Likely you need more hard drives and / or a quality caching RAID
> controller. What's your I/O subsystem look like now?
>