How I do to see my I/O subsystem? vmstat? If so, follow:[EMAIL PROTECTED] ~]# 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 <[EMAIL PROTECTED]> > On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano > <[EMAIL PROTECTED]> 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? >
