论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2005-01-19 11:23 |只看该作者 |倒序浏览

使用vacuumdb ... -a -f -z优化
程序是每笔交易会在数据库里插入一条记录，目前最多20万条，
而且它的条数也很快影响性能

不知道有什么办法避免性能下降得这么快

时间累计笔数（每分钟）
200501181900 57
200501181901 60
200501181902 61
200501181903 62
200501181904 58
200501181905 65
200501181906 68
200501181907 59
200501181908 75
200501181909 86
200501181910 94
200501181911 91
200501181912 89
200501181913 90
200501181914 86
200501181915 90
200501181916 21
200501181919 77
200501181920 85
200501181921 88
200501181922 87
200501181923 90
200501181924 91
200501181925 86
200501181926 90
200501181927 91
200501181928 89
200501181929 88
200501181930 76
200501181931 60
200501181932 91
200501181933 77
200501181934 27
200501181935 90
200501181936 93
200501181937 90
200501181938 94
200501181939 88
200501181940 93
200501181941 89
200501181942 91
200501181943 86
200501181944 52
200501181945 10
200501181946 53
---------------------------优化了一下
200501181947 310
200501181948 303
200501181949 145
200501181950 265
200501181951 195
200501181952 296
200501181953 254
200501181954 284
200501181955 288
200501181956 275
200501181957 278
200501181958 278
200501181959 266
200501182000 274
200501182001 235
200501182002 262
200501182003 220
200501182004 242
200501182005 244
200501182006 203
200501182007 243
200501182008 236
200501182009 233
200501182010 229
200501182011 225
200501182012 218
200501182013 222
200501182014 216
200501182015 216
200501182016 206
200501182017 207
200501182018 204
200501182019 198
200501182020 200
200501182021 200
200501182022 189
200501182023 184
200501182024 186
200501182025 192
200501182026 186
200501182027 186
200501182028 184
200501182029 180
200501182030 175
200501182031 181
200501182032 198
200501182033 105
200501182034 145
200501182034 2
200501182035 175
200501182036 178
200501182037 166
200501182038 172
200501182039 162
200501182040 122
200501182041 133
200501182042 144
200501182043 303
200501182044 288
200501182045 302
200501182046 300
200501182047 297
200501182048 294
200501182049 292
200501182050 290
200501182051 285
200501182052 290
200501182053 286
200501182054 280
200501182055 275
200501182056 277
200501182057 259
200501182058 251
200501182059 250
200501182100 256
200501182101 242
200501182102 257
200501182103 235
200501182104 212
200501182105 215
200501182106 202
200501182107 203
200501182108 204
200501182109 192
200501182110 185
200501182111 192
200501182112 192
200501182113 186
200501182114 189
200501182115 188
200501182116 185
200501182117 181
200501182118 187
200501182119 187
200501182120 186
200501182121 177
200501182122 176
200501182123 176
200501182124 162
200501182125 171
200501182126 174
200501182127 169
200501182128 172
200501182129 168
200501182130 174
200501182131 159
200501182132 167
200501182133 157
200501182134 161
200501182135 161
200501182136 155
200501182137 156
200501182138 161
200501182139 156
200501182140 159
200501182141 161
200501182142 156
200501182143 152
200501182144 154
200501182145 153
200501182146 157
200501182147 159
200501182148 150
200501182149 147
200501182150 150
200501182151 147
200501182152 147
200501182153 150
200501182154 139
200501182155 138
200501182156 142
200501182157 145
200501182158 144
200501182159 151
200501182200 140
200501182201 144
200501182202 137
200501182203 137
200501182204 137
200501182205 140
200501182206 141
200501182207 138
200501182208 136
200501182209 134
200501182210 135
200501182211 134
200501182212 133
200501182213 134
200501182214 126
200501182215 131
200501182216 134
200501182217 136
200501182218 131
200501182219 136
200501182220 133
200501182221 132
200501182222 134
200501182223 124
200501182224 122
200501182225 132
200501182226 128
200501182227 124
200501182228 126
200501182229 127
200501182230 130
200501182231 129
200501182232 120
200501182233 125
200501182234 120
200501182235 126
200501182236 125
200501182237 125
200501182238 124
200501182239 121
200501182240 118
200501182241 123
200501182242 121
200501182243 118
200501182244 123
200501182245 122
200501182246 116
200501182247 121
200501182248 119
200501182249 117
200501182250 126
200501182251 119
200501182252 118
200501182253 118
200501182254 115
200501182255 121
200501182256 117
200501182257 116
200501182258 116
200501182259 115
200501182300 117
200501182301 109
200501182302 110
200501182303 114
200501182304 111
200501182305 116
200501182306 110
200501182307 114
200501182308 114
200501182309 111
200501182310 111
200501182311 112
200501182312 107
200501182313 113
200501182314 107
200501182315 109
200501182316 113
200501182317 110
200501182318 108
200501182319 106
200501182320 107
200501182321 106
200501182322 109
200501182323 108
200501182324 103
200501182325 109
200501182326 110
200501182327 110
200501182328 106
200501182329 105
200501182330 103
200501182331 105
200501182332 100
200501182333 104
200501182334 101
200501182335 103
200501182336 105
200501182337 101
200501182338 105
200501182339 102
200501182340 103
200501182341 103
200501182342 101
200501182343 104
200501182344 98
200501182345 100
200501182346 97
200501182347 101
200501182348 98
200501182349 101
200501182350 101
200501182351 99
200501182352 102
200501182353 99
200501182354 95
200501182355 100
200501182356 97
200501182357 92
200501182358 96
200501182359 96
200501190000 98
200501190001 99
200501190002 98
200501190003 99
200501190004 91
200501190005 93
200501190006 96
200501190007 96
200501190008 95
200501190009 95
200501190010 90
200501190011 96
200501190012 97
200501190013 96
200501190014 96
200501190015 96
200501190016 91
200501190017 93
200501190018 94
200501190019 93
200501190020 96
200501190021 96
200501190022 95
200501190023 96
200501190024 90
200501190025 96
200501190026 94
200501190027 92
200501190028 95
200501190029 94
200501190030 89
200501190031 94
200501190032 91
200501190033 94
200501190034 93
200501190035 86
200501190036 90
200501190037 92
200501190038 94
200501190039 91
200501190040 92
200501190041 93
200501190042 83
200501190043 92
200501190044 89
200501190045 89
200501190046 90
200501190047 90
200501190048 88
200501190049 88
200501190050 88
200501190051 86
200501190052 89
200501190053 86
200501190054 82
200501190055 87
200501190056 90
200501190057 89
200501190058 89
200501190059 84
200501190100 87
200501190101 87
200501190102 86
200501190103 86
200501190104 81
200501190105 86
200501190106 86
200501190107 80
200501190108 86
200501190109 83
200501190110 84
200501190111 87
200501190112 88
200501190113 85
200501190114 81
200501190115 83
200501190116 85
200501190117 80
200501190118 83
200501190119 82
200501190120 80
200501190121 81
200501190122 85
200501190123 84
200501190124 80
200501190125 85
200501190126 81
200501190127 83
200501190128 82
200501190129 83
200501190130 81
200501190131 84
200501190132 83
200501190133 80
200501190134 79
200501190135 83
200501190136 80
200501190137 82
200501190138 80
200501190139 79
200501190140 81
200501190141 79
200501190142 80
200501190143 78
200501190144 81
200501190145 81
200501190146 78
200501190147 81
200501190148 77
200501190149 80
200501190150 78
200501190151 80
200501190152 80
200501190153 79
200501190154 78
200501190155 82
200501190156 74
200501190157 74
200501190158 76
200501190159 76
200501190200 79
200501190201 75
200501190202 74
200501190203 77
200501190204 75
200501190205 80
200501190206 74
200501190207 79
200501190208 79
200501190209 74
200501190210 79
200501190211 79
200501190212 73
200501190213 74
200501190214 77
200501190215 70
200501190216 81
200501190217 76
200501190218 75
200501190219 75
200501190220 76
200501190221 76
200501190222 76
200501190223 74
200501190224 77
200501190225 72
200501190226 75
200501190227 74
200501190228 75
200501190229 72
200501190230 74
200501190231 73
200501190232 79
200501190233 69
200501190234 74
200501190235 76
200501190236 73
200501190237 74
200501190238 76
200501190239 71
200501190240 74
200501190241 75
200501190242 70
200501190243 76
200501190244 72
200501190245 71
200501190246 74
200501190247 75
200501190248 72
200501190249 67
200501190250 75
200501190251 73
200501190252 73
200501190253 68
200501190254 73
200501190255 71
200501190256 73
200501190257 71
200501190258 73
200501190259 70
200501190300 70
200501190301 73
200501190302 71
200501190303 72
200501190304 68
200501190305 71
200501190306 73
200501190307 70
200501190308 73
200501190309 69
200501190310 71
200501190311 75
200501190312 70
200501190313 73
200501190314 69
200501190315 72
200501190316 69
200501190317 71
200501190318 72
200501190319 68
200501190320 71

时间累计笔数
200501190320 71
200501190321 71
200501190322 68
200501190323 70
200501190324 69
200501190325 73
200501190326 69
200501190327 70
200501190328 71
200501190329 68
200501190330 72
200501190331 69
200501190332 69
200501190333 67
200501190334 68
200501190335 68
200501190336 69
200501190337 72
200501190338 70
200501190339 66
200501190340 69
200501190341 68
200501190342 68
200501190343 65
200501190344 69
200501190345 68
200501190346 66
200501190347 70
200501190348 67
200501190349 67
200501190350 70
200501190351 68
200501190352 67
200501190353 69
200501190354 69
200501190355 68
200501190356 68
200501190357 70
200501190358 65
200501190359 65
200501190400 68
200501190401 63
200501190402 57
200501190403 51
200501190404 63
200501190405 63
200501190406 63
200501190407 60
200501190408 61
200501190409 61
200501190410 62
200501190411 63
200501190412 60
200501190413 61
200501190414 58
200501190415 62
200501190416 61
200501190417 62
200501190418 62
200501190419 59
200501190420 56
200501190421 61
200501190422 61
200501190423 60
200501190424 59
200501190425 58
200501190426 61
200501190427 60
200501190428 61
200501190429 59
200501190430 54
200501190431 62
200501190432 59
200501190433 59
200501190434 58
200501190435 57
200501190436 60
200501190437 60
200501190438 60
200501190439 58
200501190440 61
200501190441 57
200501190442 63
200501190443 64
200501190444 60
200501190445 57
200501190446 50
200501190447 50
200501190448 51
200501190449 51
200501190450 48
200501190451 48
200501190452 50
200501190453 53
200501190454 47
200501190455 51
200501190456 46
200501190457 49
200501190458 48
200501190459 50
200501190500 50
200501190501 49
200501190502 48
200501190503 47
200501190504 51
200501190505 49
200501190506 52
200501190507 44
200501190508 49
200501190509 48
200501190510 50
200501190511 51
200501190512 50
200501190513 52
200501190514 54
200501190515 53
200501190516 55
200501190517 52
200501190518 54
200501190519 50
200501190520 55
200501190521 51
200501190522 52
200501190523 51
200501190524 53
200501190525 52
200501190526 52
200501190527 53
200501190528 54
200501190529 54
200501190530 52
200501190531 52
200501190532 51
200501190533 54
200501190534 51
200501190535 55
200501190536 53
200501190537 54
200501190538 51
200501190539 52
200501190540 52
200501190541 54
200501190542 48
200501190543 54
200501190544 49
200501190545 50
200501190546 51
200501190547 54
200501190548 50
200501190549 53
200501190550 49
200501190551 53
200501190552 49
200501190553 53
200501190554 49
200501190555 53
200501190556 49
200501190557 53
200501190558 51
200501190559 51
200501190600 51
200501190601 52
200501190602 51
200501190603 51
200501190604 49
200501190605 53
200501190606 49
200501190607 52
200501190608 50
200501190609 51
200501190610 50
200501190611 51
200501190612 52
200501190613 49
200501190614 52
200501190615 51
200501190616 51
200501190617 49
200501190618 52
200501190619 48
200501190620 51
200501190621 50
200501190622 50
200501190623 50
200501190624 52
200501190625 47
200501190626 50
200501190627 48
200501190628 52
200501190629 47
200501190630 48
200501190631 50
200501190632 50
200501190633 48
200501190634 49
200501190635 48
200501190636 50
200501190637 50
200501190638 49
200501190639 48
200501190640 50
200501190641 50
200501190642 50
200501190643 50
200501190644 48
200501190645 47
200501190646 50
200501190647 50
200501190648 49
200501190649 48
200501190650 47
200501190651 50
200501190652 49
200501190653 48
200501190654 47
200501190655 47
200501190656 49
200501190657 48
200501190658 47
200501190659 49
200501190700 48
200501190701 49
200501190702 46
200501190703 50
200501190704 46
200501190705 48
200501190706 47
200501190707 49
200501190708 46
200501190709 46
200501190710 50
200501190711 45
200501190712 49
200501190713 49
200501190714 45
200501190715 48
200501190716 47
200501190717 49
200501190718 48
200501190719 46
200501190720 48
200501190721 46
200501190722 47
200501190723 48
200501190724 46
200501190725 47
200501190726 49
200501190727 46
200501190728 47
200501190729 46
200501190730 48
200501190731 47
200501190732 48
200501190733 45
200501190734 49
200501190735 45
200501190736 49
200501190737 44
200501190738 48
200501190739 44
200501190740 50
200501190741 45
200501190742 46
200501190743 46
200501190744 47
200501190745 47
200501190746 47
200501190747 46
200501190748 48
200501190749 45
200501190750 47
200501190751 45
200501190752 44
200501190753 45
200501190754 47
200501190755 45
200501190756 46
200501190757 48
200501190758 45
200501190759 48
200501190800 42
200501190801 48
200501190802 42
200501190803 47
200501190804 45
200501190805 47
200501190806 44
200501190807 48
200501190808 43
200501190809 49
200501190810 42
200501190811 46
200501190812 44
200501190813 46
200501190814 44
200501190815 46
200501190816 44
200501190817 47
200501190818 45
200501190819 44
200501190820 44
200501190821 45
200501190822 45
200501190823 45
200501190824 45
200501190825 44
200501190826 47
200501190827 44
200501190828 46
200501190829 42
200501190830 47
200501190831 42
200501190832 47
200501190833 44
200501190834 45
200501190835 44
200501190836 46
200501190837 44
200501190838 45
200501190839 45
200501190840 45
200501190841 45
200501190842 46
200501190843 45
200501190844 43
200501190845 43
200501190846 45
200501190847 42
200501190848 47
200501190849 39
200501190850 45
200501190851 44
200501190852 45
200501190853 43
200501190854 43
200501190855 46
200501190856 44
200501190857 44
200501190858 42
200501190859 44
200501190900 42
200501190901 46
200501190902 39
200501190903 36
200501190904 31

时间累计笔数
200501190905 44
200501190906 39
200501190907 45
200501190908 16
200501190909 4
200501190910 4
200501190911 1
---------------------------优化了一下
200501190912 160
200501190913 166
200501190914 167
200501190915 171
200501190916 109
200501190918 61
200501190919 278
200501190920 285－－效果有点不如上次优化后的效果
200501190921 274
200501190922 288
200501190923 280
200501190924 266
200501190925 283
200501190926 266
200501190927 271
200501190928 258
200501190929 257
200501190930 257
200501190931 259
200501190932 252
200501190933 254
200501190934 239
200501190935 242
200501190936 232
200501190937 237
200501190938 231
200501190939 227
200501190940 225
200501190941 232
200501190942 224
200501190943 228
200501190944 218
200501190945 224
200501190946 212
200501190947 221
200501190948 214
200501190949 207
200501190950 213
200501190951 207
200501190952 209
200501190953 208
200501190954 207
200501190955 206
200501190956 200
200501190957 200
200501190958 199
200501190959 193
200501191000 200
200501191001 194
200501191002 193
200501191003 186
200501191004 193
200501191005 192
200501191006 191
200501191007 188
200501191008 196
200501191009 151
200501191010 152
200501191011 180
200501191012 173
200501191013 184
200501191014 180
200501191015 184
200501191016 176
200501191017 180
200501191018 182
200501191019 173
200501191020 180
200501191021 176
200501191022 172
200501191023 174
200501191024 173
200501191025 173
200501191026 166
200501191027 175
200501191028 188
200501191029 195
200501191030 198
200501191031 193
200501191032 188
200501191033 187
200501191034 185
200501191035 185
200501191036 183
200501191037 187
200501191038 182
200501191039 177
200501191040 184
200501191041 183
200501191042 182
200501191043 175
200501191044 176
200501191045 179
200501191046 181
200501191047 177
200501191048 182
200501191049 170
200501191050 176
200501191051 172
200501191052 145