Re: Vacuum Problems
| От | Rafael Domiciano |
|---|---|
| Тема | Re: Vacuum Problems |
| Дата | |
| Msg-id | 3a0028490812080811r1c8a4756i1a1a514911741def@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuum Problems ("Scott Marlowe" <scott.marlowe@gmail.com>) |
| Ответы |
Re: Vacuum Problems
("Scott Marlowe" <scott.marlowe@gmail.com>)
|
| Список | pgsql-admin |
How I do to see my I/O subsystem? vmstat? If so, follow:
[root@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.marlowe@gmail.com>
On Mon, Dec 8, 2008 at 6:04 AM, Rafael DomicianoLikely you need more hard drives and / or a quality caching RAID
<rafael.domiciano@gmail.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?
controller. What's your I/O subsystem look like now?
В списке pgsql-admin по дате отправления: