안녕하세요
postgresql를 사용하는데 프로그램을 돌리면서 장시간 스트레스 테스트를 하다가 보면 심한 성능하락이 발생합니다.
이것을 해결할수 있는 방법이 있을까요
vacuumdb -a -z
클린을 시켜 줘도 그때 뿐이고 근본적인 해결은 안되었습니다.
시스템 성능은 cpu z510 램 1G 하드 160G 입니다.
조언 부탁 드립니다.
top - 16:12:22 up 4 days, 6:22, 6 users, load average: 6.89, 6.05, 5.23
Tasks: 130 total, 6 running, 119 sleeping, 0 stopped, 5 zombie
Cpu(s): 50.0%us, 48.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 1.9%si, 0.0%st
Mem: 1029472k total, 1013272k used, 16200k free, 19192k buffers
Swap: 0k total, 0k used, 0k free, 861640k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7187 postgres 16 0 22888 11m 10m S 75.4 1.1 109:18.87 postmaster
7186 postgres 15 0 22896 11m 10m S 2.9 1.1 335:44.15 postmaster
5027 postgres 15 0 23452 11m 10m S 1.9 1.1 25:06.83 postmaster
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
6 0 0 15604 19124 860820 0 0 0 32 1050 3443 53 44 0 3 0
6 0 0 15480 19124 860924 0 0 0 24 1041 3425 58 42 0 0 0
3 0 0 15356 19124 861028 0 0 0 168 1013 2559 54 46 0 0 0
2 0 0 15108 19124 861140 0 0 0 32 1053 3515 54 46 0 0 0
1 0 0 15108 19132 861236 0 0 0 1124 746 1508 40 60 0 0 0
6 0 0 14860 19132 861328 0 0 0 24 1062 3299 55 45 0 0 0
2 0 0 14860 19132 861432 0 0 0 32 1041 3216 48 51 0 1 0
3 0 0 14736 19132 861572 0 0 0 256 998 2955 52 47 0 1 0
6 0 0 14612 19132 861728 0 0 0 24 1051 3416 54 44 0 2 0
19 1 0 14488 19140 861832 0 0 0 956 1040 2566 44 53 0 3 0
2 1 0 14364 19140 861936 0 0 0 40 1041 3420 51 49 0 0 0
1 0 0 14240 19140 862076 0 0 0 24 1062 3373 53 46 0 1 0
3 0 0 14116 19140 862180 0 0 0 112 1035 3358 54 46 0 0 0
6 0 0 13992 19140 862288 0 0 0 24 1058 3263 53 44 0 3 0
5 0 0 13868 19140 862444 0 0 0 32 1059 3453 56 44 0 0 0
3 0 0 13868 19148 862488 0 0 0 1048 778 1607 45 55 0 0 0
3 0 0 13744 19148 862644 0 0 0 32 1045 2932 55 45 0 0 0
1 0 0 13620 19148 862748 0 0 0 24 1055 3269 53 47 0 0 0
1 0 0 13496 19148 862900 0 0 0 32 1043 3490 56 44 0 0 0
10 0 0 13248 19148 863004 0 0 0 24 1056 3474 52 46 0 2 0
15 0 0 13248 19148 863084 0 0 0 1132 1021 1836 48 52 0 0 0
8 0 0 13124 19152 863236 0 0 0 56 1049 3216 53 47 0 0 0
4 0 0 12972 19152 863340 0 0 0 48 1049 3356 54 46 0 0 0
3 0 0 16276 19096 860072 0 0 0 148 1015 2722 54 46 0 0 0
4 0 0 16276 19096 860208 0 0 0 48 1039 3454 56 44 0 0 0
3 0 0 16220 19096 860324 0 0 0 48 1039 3506 52 47 0 1 0
5 0 0 15848 19108 860416 0 0 0 1108 759 1789 42 58 0 0 0
8 0 0 16348 19140 860516 0 0 0 524 929 2499 49 51 0 0 0
5 0 0 16472 19140 860620 0 0 0 56 1043 3230 54 46 0 0 0
1 0 0 16472 19140 860780 0 0 0 248 1041 3172 51 49 0 0 0
1 0 0 16472 19140 860884 0 0 0 24 1058 2718 57 43 0 0 0
1 0 0 16348 19140 860992 0 0 0 48 1051 3423 51 46 0 3 0
17 0 0 16224 19148 861140 0 0 0 1184 933 2160 44 56 0 0 0
3 0 0 16224 19148 861220 0 0 0 48 1048 3375 51 48 0 1 0
6 0 0 15976 19148 861376 0 0 0 88 1029 3319 54 46 0 0 0
1 0 0 15976 19148 861488 0 0 0 48 1053 3286 55 45 0 0 0
11 1 0 15232 19152 861588 0 0 0 1020 914 2032 43 57 0 0 0
2 0 0 15232 19156 861716 0 0 0 68 1060 2800 56 44 0 0 0
4 0 0 15232 19156 861872 0 0 0 72 1031 3310 54 46 0 0 0
2 0 0 15232 19156 861988 0 0 0 24 1070 3409 54 46 0 0 0
3 0 0 15232 19156 862092 0 0 0 232 998 3172 52 48 0 0 0
3 0 0 15108 19156 862248 0 0 0 40 1062 3471 53 45 0 2 0
1 0 0 14984 19164 862332 0 0 0 992 803 1691 46 54 0 0 0
3 0 0 14860 19168 862432 0 0 0 24 1052 3360 55 44 0 1 0
3 0 0 13124 19200 862480 0 0 0 892 816 1849 40 55 0 4 0
|