{"id":20720,"date":"2025-11-19T17:26:34","date_gmt":"2025-11-19T09:26:34","guid":{"rendered":"https:\/\/www.orczhou.com\/?page_id=20720"},"modified":"2026-03-14T09:28:48","modified_gmt":"2026-03-14T01:28:48","slug":"cloud-database-rds-postgresql-performance","status":"publish","type":"page","link":"https:\/\/www.orczhou.com\/index.php\/cloud-database-rds-postgresql-performance\/","title":{"rendered":"\u4e91\u5382\u5546 RDS PostgreSQL \u6027\u80fd\u5bf9\u6bd4"},"content":{"rendered":"\n<p>\u5728\u4e0d\u540c\u7684\u4e91\u5382\u5546\uff0c\u8d2d\u4e70\u76f8\u540c\u89c4\u683c\u7684 PostgreSQL \u5b9e\u4f8b\uff0c\u83b7\u5f97\u7684\u6027\u80fd\u76f8\u540c\u5417\uff1f\u672c\u6587\u4f7f\u7528 HammerDB\uff0c\u5bf9\u4e0d\u540c\u4e91\u5382\u5546\u7684\u540c\u6837\u89c4\u683c\u201c4vCPU-16GB\u201d\u8fdb\u884c\u6027\u80fd\u6d4b\u8bd5\u6765\u5c1d\u8bd5\u56de\u7b54\u4e0a\u8ff0\u95ee\u9898\u3002<\/p>\n\n\n<div>    <script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['corechart','line']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n        ['threads\/qps', 'aliyun',{type:'string', role:'annotation'},'tencent',{type:'string', role:'annotation'},'baidu','huawei','google','azure','aws'],\n['4',111595,111595,71942,71942,63127,48948,52766,32721,45142],\n['8',119127,119127,131820,131820,114384,107971,67060,57608,66258],\n['16',114861,114861,205286,205286,173518,137311,69745,65859,74701],\n['32',121721,121721,239611,239611,202612,168526,50951,77778,93421],\n['48',167499,167499,245468,245468,212537,160690,53195,58136,86206],\n['64',219941,219941,253374,253374,211387,171571,58771,65658,78844],\n['96',272737,272737,255348,255348,214521,145009,73041,68001,72988],\n['128',295949,295949,256283,256283,221967,165685,80804,65344,73394],\n['192',187361,187361,249002,249002,175506,157009,88645,51834,71731],\n['256',232846,232846,243367,243367,173140,151988,96277,46385,57158],\n['384',182860,182860,219641,219641,166586,148380,101374,46103,61129],\n['512',211111,211111,202334,202334,162274,123454,97850,51438,48812],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud PostgreSQL at 202511',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-3000iops-Multi-az-by-HammerDB',\n          curveType: 'none',\n          lineWidth:1.5,\n          chartArea:{left:90,bottom:70,top:24},\n          hAxis:{\n            title: 'Concurrent Users',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          vAxis: {\n            title: 'TPM for TPCC',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          legend: {\n            position: 'right',\n            textStyle: {fontSize: 18},\n            maxLines:8,\n            alignment:'start',\n          },\n          series: {             0: {\n                                  color: '#ff6a00',\n                 pointShape:'star',\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff6a00',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            1: {\n                                  color: '#0052d9',\n                 pointShape:'circle',\n                 pointSize: 4,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0052d9',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            2: {\n                                  color: '#2418dd',\n                 pointShape:'diamond',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#2418dd',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            3: {\n                                  color: '#cd0d2d',\n                 pointShape:'square',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#cd0d2d',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            4: {\n                                  color: '#34a853',\n                 pointShape:{ type: 'star', sides: 5,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#34a853',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            5: {\n                                  color: '#0389d6',\n                 pointShape:{ type: 'star', sides: 4,rotation:45 },\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0389d6',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            6: {\n                                  color: '#141e2e',\n                 pointShape:'triangle',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#141e2e',\n                     opacity: 0.8\n                   }\n                 },\n               },\n },\n          width: 1100,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_postgresql_s06'));\n\/*\n *      set subtitle, ref:\n *          https:\/\/stackoverflow.com\/questions\/41893055\/add-subtitle-in-areachart-in-google-chart\n *\n * *\/\n        var container = document.getElementById('chart_div_postgresql_s06');\n        google.visualization.events.addListener(chart, 'ready', function () {\n          Array.prototype.forEach.call(container.getElementsByTagName('text'), function(label) {\n            if (label.innerHTML === options.title) {\n              var subtitle = label.parentNode.appendChild(label.cloneNode(true));\n              subtitle.innerHTML = '4vCPU16GB-100GB-3000iops-Multi-az-by-HammerDB';\n              subtitle.setAttribute('font-size', 10 );\n              subtitle.style.fontSize = \"10px\";\n              subtitle.style.fill = \"gray\";\n              \/\/subtitle.setAttribute(\"style\", \"color: green;\");\n              subtitle.setAttribute('y', parseFloat(label.getAttribute('y')) + 20);\n            }\n          });\n        });\n        chart.draw(data, options);\n      }\n    <\/script>\n    <div id=\"chart_div_postgresql_s06\" style=\"\"><\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">HammerDB NOPM \u8be6\u7ec6\u6570\u636e<\/h4>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:90%\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>111595<\/td><td>45142<\/td><td>32721<\/td><td>63127<\/td><td>52766<\/td><td>48948<\/td><td>71942<\/td><tr><td>8<\/td><td>119127<\/td><td>66258<\/td><td>57608<\/td><td>114384<\/td><td>67060<\/td><td>107971<\/td><td>131820<\/td><tr><td>16<\/td><td>114861<\/td><td>74701<\/td><td>65859<\/td><td>173518<\/td><td>69745<\/td><td>137311<\/td><td>205286<\/td><tr><td>32<\/td><td>121721<\/td><td>93421<\/td><td>77778<\/td><td>202612<\/td><td>50951<\/td><td>168526<\/td><td>239611<\/td><tr><td>48<\/td><td>167499<\/td><td>86206<\/td><td>58136<\/td><td>212537<\/td><td>53195<\/td><td>160690<\/td><td>245468<\/td><tr><td>64<\/td><td>219941<\/td><td>78844<\/td><td>65658<\/td><td>211387<\/td><td>58771<\/td><td>171571<\/td><td>253374<\/td><tr><td>96<\/td><td>272737<\/td><td>72988<\/td><td>68001<\/td><td>214521<\/td><td>73041<\/td><td>145009<\/td><td>255348<\/td><tr><td>128<\/td><td>295949<\/td><td>73394<\/td><td>65344<\/td><td>221967<\/td><td>80804<\/td><td>165685<\/td><td>256283<\/td><tr><td>192<\/td><td>187361<\/td><td>71731<\/td><td>51834<\/td><td>175506<\/td><td>88645<\/td><td>157009<\/td><td>249002<\/td><tr><td>256<\/td><td>232846<\/td><td>57158<\/td><td>46385<\/td><td>173140<\/td><td>96277<\/td><td>151988<\/td><td>243367<\/td><tr><td>384<\/td><td>182860<\/td><td>61129<\/td><td>46103<\/td><td>166586<\/td><td>101374<\/td><td>148380<\/td><td>219641<\/td><tr><td>512<\/td><td>211111<\/td><td>48812<\/td><td>51438<\/td><td>162274<\/td><td>97850<\/td><td>123454<\/td><td>202334<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:5%\"><\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Latency (Event) \u8be6\u7ec6\u6570\u636e<\/h4>\n\n\n\n<p>\u5982\u4e0b\u8868\u683c\u5206\u522b\u4e3a\uff1a\u521b\u5efa\u8ba2\u5355\u7684\u5e73\u5747\u5ef6\u8fdf \u548c 95%\u5ef6\u8fdf\u6570\u636e\uff0c\u5355\u4f4d\u4e3a\u6beb\u79d2\/ms\u3002<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"font-size:12px\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>3.19<\/td><td>6.05<\/td><td>9.54<\/td><td>4.29<\/td><td>6.08<\/td><td>6.16<\/td><td>3.80<\/td><tr><td>8<\/td><td>6.09<\/td><td>7.95<\/td><td>10.53<\/td><td>4.51<\/td><td>7.97<\/td><td>5.09<\/td><td>4.23<\/td><tr><td>16<\/td><td>11.38<\/td><td>13.09<\/td><td>15.95<\/td><td>5.77<\/td><td>15.14<\/td><td>8.56<\/td><td>5.39<\/td><tr><td>32<\/td><td>18.98<\/td><td>20.60<\/td><td>25.55<\/td><td>9.77<\/td><td>37.82<\/td><td>12.46<\/td><td>8.80<\/td><tr><td>48<\/td><td>21.95<\/td><td>35.12<\/td><td>48.41<\/td><td>13.93<\/td><td>54.92<\/td><td>19.36<\/td><td>12.62<\/td><tr><td>64<\/td><td>19.41<\/td><td>50.48<\/td><td>63.06<\/td><td>18.43<\/td><td>68.49<\/td><td>23.96<\/td><td>16.25<\/td><tr><td>96<\/td><td>25.59<\/td><td>75.96<\/td><td>86.31<\/td><td>27.12<\/td><td>84.84<\/td><td>37.88<\/td><td>23.57<\/td><tr><td>128<\/td><td>34.84<\/td><td>103.47<\/td><td>110.78<\/td><td>33.48<\/td><td>109.53<\/td><td>46.83<\/td><td>32.78<\/td><tr><td>192<\/td><td>74.04<\/td><td>172.39<\/td><td>213.28<\/td><td>61.81<\/td><td>158.71<\/td><td>77.42<\/td><td>53.39<\/td><tr><td>256<\/td><td>82.84<\/td><td>259.21<\/td><td>354.64<\/td><td>81.40<\/td><td>207.35<\/td><td>109.57<\/td><td>74.94<\/td><tr><td>384<\/td><td>118.81<\/td><td>442.18<\/td><td>552.18<\/td><td>129.39<\/td><td>309.36<\/td><td>189.03<\/td><td>127.98<\/td><tr><td>512<\/td><td>138.27<\/td><td>715.55<\/td><td>670.41<\/td><td>NA<\/td><td>NA<\/td><td>268.33<\/td><td>166.06<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"font-size:12px\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>4<\/td><td>12.98<\/td><td>7.34<\/td><td>17.86<\/td><td>5.30<\/td><td>11.90<\/td><td>9.70<\/td><td>4.63<\/td><tr><td>8<\/td><td>32.59<\/td><td>8.16<\/td><td>23.25<\/td><td>6.42<\/td><td>15.21<\/td><td>8.64<\/td><td>9.02<\/td><tr><td>16<\/td><td>57.49<\/td><td>12.61<\/td><td>36.96<\/td><td>9.62<\/td><td>24.18<\/td><td>17.62<\/td><td>11.29<\/td><tr><td>32<\/td><td>79.11<\/td><td>35.39<\/td><td>60.93<\/td><td>17.85<\/td><td>180.64<\/td><td>25.09<\/td><td>19.43<\/td><tr><td>48<\/td><td>81.58<\/td><td>73.03<\/td><td>108.89<\/td><td>26.58<\/td><td>219.19<\/td><td>39.58<\/td><td>28.93<\/td><tr><td>64<\/td><td>69.04<\/td><td>96.63<\/td><td>143.82<\/td><td>38.81<\/td><td>235.47<\/td><td>48.72<\/td><td>39.73<\/td><tr><td>96<\/td><td>80.18<\/td><td>214.22<\/td><td>189.59<\/td><td>60.60<\/td><td>255.97<\/td><td>86.25<\/td><td>56.84<\/td><tr><td>128<\/td><td>101.78<\/td><td>455.31<\/td><td>255.32<\/td><td>80.27<\/td><td>299.24<\/td><td>102.16<\/td><td>89.65<\/td><tr><td>192<\/td><td>199.72<\/td><td>870.53<\/td><td>550.73<\/td><td>171.94<\/td><td>401.29<\/td><td>195.37<\/td><td>143.30<\/td><tr><td>256<\/td><td>251.30<\/td><td>1052.08<\/td><td>978.31<\/td><td>237.99<\/td><td>563.66<\/td><td>274.02<\/td><td>176.93<\/td><tr><td>384<\/td><td>371.82<\/td><td>1899.69<\/td><td>1706.44<\/td><td>424.60<\/td><td>842.40<\/td><td>469.09<\/td><td>391.07<\/td><tr><td>512<\/td><td>452.25<\/td><td>3219.20<\/td><td>2133.27<\/td><td>NA<\/td><td>NA<\/td><td>730.46<\/td><td>522.09<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u53c2\u6570\u8868<\/h4>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column has-x-small-font-size is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\"><div><table class=\"pure-table pure-table-bordered\" style=\"font-size:0.8em;width:100%\"><thead><tr><th>data<\/th><th>aliyun<\/th><th>aws<\/th><th>azure<\/th><th>baidu<\/th><th>google<\/th><th>huawei<\/th><th>tencent<\/th><\/tr><\/thead><tbody><tr><td>autovacuum<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><tr><td>block_size<\/td><td>8192<\/td><td>8192<\/td><td>8192<\/td><td>8192<\/td><td>8192<\/td><td>8192<\/td><td>8192<\/td><tr><td>effective_cache_size<\/td><td>1048576<\/td><td>992280<\/td><td>1572864<\/td><td>1179648<\/td><td>819142<\/td><td>1572864<\/td><td>524288<\/td><tr><td>cache_size_in_GB<\/td><td>8 GB<\/td><td>7.57 GB<\/td><td>12 GB<\/td><td>9 GB<\/td><td>6.25 GB<\/td><td>12 GB<\/td><td>4 GB<\/td><tr><td>fsync<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><tr><td>max_connections<\/td><td>1620<\/td><td>1705<\/td><td>1718<\/td><td>1600<\/td><td>500<\/td><td>768<\/td><td>2048<\/td><tr><td>max_worker_processes<\/td><td>8<\/td><td>8<\/td><td>8<\/td><td>8<\/td><td>8<\/td><td>8<\/td><td>8<\/td><tr><td>shared_buffers<\/td><td>489705<\/td><td>496140<\/td><td>524288<\/td><td>589824<\/td><td>682496<\/td><td>524288<\/td><td>524288<\/td><tr><td>shared_buffers_in_GB<\/td><td>3.74 GB<\/td><td>3.79 GB<\/td><td>4 GB<\/td><td>4.5 GB<\/td><td>5.21 GB<\/td><td>4 GB<\/td><td>4 GB<\/td><tr><td>synchronous_commit<\/td><td>off<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><td>on<\/td><tr><td>synchronous_standby_names<\/td><td><\/td><td><\/td><td>ANY 1 ( \"azure_...<\/td><td><\/td><td><\/td><td>ANY 1 (dbnode1)<\/td><td>athena_23671246...<\/td><tr><td>wal_buffers<\/td><td>8192<\/td><td>8192<\/td><td>2048<\/td><td>2048<\/td><td>2048<\/td><td>2048<\/td><td>2048<\/td><tr><td>wal_writer_delay<\/td><td>200<\/td><td>200<\/td><td>200<\/td><td>200<\/td><td>200<\/td><td>200<\/td><td>200<\/td><tr><td>instance_type<\/td><td>pg.x4.large.2c<\/td><td>db.m7i.xlarge<\/td><td>GP_Standard_D4ds_v5<\/td><td>4<\/td><td>db-custom-4-16384<\/td><td>rds.pg.x1.xlarge.4.ha<\/td><td>4c<\/td><tr><td>storage_type<\/td><td>cloud_essd<\/td><td>io1<\/td><td>NA<\/td><td>cloud_enha<\/td><td>NA<\/td><td>CLOUDSSD<\/td><td>NA<\/td><tr><td>storage_size<\/td><td>100<\/td><td>100<\/td><td>128<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><tr><td>storage_iops<\/td><td>NA<\/td><td>3000<\/td><td>P20<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><td>NA<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5386\u53f2\u6d4b\u8bd5\u6570\u636e<\/h4>\n\n\n<div>    <script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['corechart','line']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n        ['threads\/qps', 'tencent',{type:'string', role:'annotation'},'oracle','baidu','aliyun',{type:'string', role:'annotation'},'huawei','google','aws','azure',{type:'string', role:'annotation'}],\n['4',75886,75886,112357,73928,121201,121201,48300,35751,44633,28850,28850],\n['8',142098,142098,167449,137354,124474,124474,102566,61107,65841,51456,51456],\n['16',204876,204876,184726,181829,118806,118806,140669,67955,88528,67581,67581],\n['32',241408,241408,198985,216409,298571,298571,153915,52331,92037,81197,81197],\n['48',257232,257232,211805,226102,294649,294649,174672,53532,82849,62307,62307],\n['64',265421,265421,216221,223582,236332,236332,161111,57627,99242,66739,66739],\n['96',268821,268821,214590,228040,273594,273594,170247,66397,67087,67891,67891],\n['128',261293,261293,202259,230405,195982,195982,176858,73498,69674,66092,66092],\n['192',262508,262508,197894,219121,196068,196068,169217,84453,56282,47519,47519],\n['256',255733,255733,192202,206829,148792,148792,143520,92273,46718,44770,44770],\n['384',236775,236775,181954,154339,151165,151165,158164,92035,62358,45063,45063],\n['512',214187,214187,174902,154647,154211,154211,143114,92342,76844,42946,42946],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud PostgreSQL 202507',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-3000iops-Multi-az-by-HammerDB\/orczhou',\n          curveType: 'none',\n          lineWidth:1.5,\n          chartArea:{left:90,bottom:70,top:24},\n          hAxis:{\n            title: 'Concurrent Users',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          vAxis: {\n            title: 'TPM for TPCC',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          legend: {\n            position: 'right',\n            textStyle: {fontSize: 18},\n            maxLines:8,\n            alignment:'start',\n          },\n          series: {             0: {\n                                  color: '#0052d9',\n                 pointShape:'circle',\n                 pointSize: 4,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0052d9',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            1: {\n                                  color: '#ff0000',\n                 pointShape:{ type: 'star', sides: 6,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff0000',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            2: {\n                                  color: '#2418dd',\n                 pointShape:'diamond',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#2418dd',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            3: {\n                                  color: '#ff6a00',\n                 pointShape:'star',\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff6a00',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            4: {\n                                  color: '#cd0d2d',\n                 pointShape:'square',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#cd0d2d',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            5: {\n                                  color: '#34a853',\n                 pointShape:{ type: 'star', sides: 5,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#34a853',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            6: {\n                                  color: '#141e2e',\n                 pointShape:'triangle',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#141e2e',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            7: {\n                                  color: '#0389d6',\n                 pointShape:{ type: 'star', sides: 4,rotation:45 },\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0389d6',\n                     opacity: 0.8\n                   }\n                 },\n               },\n },\n          width: 1100,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_postgresql_s05'));\n\/*\n *      set subtitle, ref:\n *          https:\/\/stackoverflow.com\/questions\/41893055\/add-subtitle-in-areachart-in-google-chart\n *\n * *\/\n        var container = document.getElementById('chart_div_postgresql_s05');\n        google.visualization.events.addListener(chart, 'ready', function () {\n          Array.prototype.forEach.call(container.getElementsByTagName('text'), function(label) {\n            if (label.innerHTML === options.title) {\n              var subtitle = label.parentNode.appendChild(label.cloneNode(true));\n              subtitle.innerHTML = '4vCPU16GB-100GB-3000iops-Multi-az-by-HammerDB\/orczhou';\n              subtitle.setAttribute('font-size', 10 );\n              subtitle.style.fontSize = \"10px\";\n              subtitle.style.fill = \"gray\";\n              \/\/subtitle.setAttribute(\"style\", \"color: green;\");\n              subtitle.setAttribute('y', parseFloat(label.getAttribute('y')) + 20);\n            }\n          });\n        });\n        chart.draw(data, options);\n      }\n    <\/script>\n    <div id=\"chart_div_postgresql_s05\" style=\"\"><\/div><\/div>\n\n\n<div>    <script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['corechart','line']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n        ['threads\/qps', 'tencent',{type:'string', role:'annotation'},'oracle','baidu','aliyun',{type:'string', role:'annotation'},'huawei','gcp','aws','azure',{type:'string', role:'annotation'}],\n['4',74783,74783,102960,85153,105382,105382,49576,56976,45424,29605,29605],\n['8',126970,126970,142414,149599,121114,121114,106395,67368,67263,56614,56614],\n['16',177235,177235,164306,192561,118650,118650,140129,70518,84541,51592,51592],\n['32',216858,216858,169844,229771,246043,246043,157498,51984,82031,69227,69227],\n['48',223459,223459,192757,222719,235797,235797,167994,53353,90991,78410,78410],\n['64',223239,223239,197916,226379,204646,204646,155531,58469,86701,73981,73981],\n['96',233589,233589,194669,222302,202819,202819,172578,70861,80548,62383,62383],\n['128',253656,253656,190936,209349,212617,212617,157889,79784,73944,58427,58427],\n['192',264530,264530,178817,209416,193311,193311,152882,86258,67332,59813,59813],\n['256',263375,263375,175086,188817,198983,198983,146299,98694,66205,62228,62228],\n['384',255405,255405,164207,169635,187266,187266,153254,103058,75611,44816,44816],\n['512',252106,252106,166710,160723,159119,159119,120810,90334,72599,44802,44802],\n ]);\n        var options = {\n          title: 'Benchmark for Cloud PostgreSQL 202504',\n          titleTextStyle: { color: '#4285f4', fontSize: 20, bold: true},\n          subtitle: '4vCPU16GB-100GB-3000iops-Multi-az-by-HammerDB\/orczhou',\n          curveType: 'none',\n          lineWidth:1.5,\n          chartArea:{left:90,bottom:70,top:24},\n          hAxis:{\n            title: 'Concurrent Users',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          vAxis: {\n            title: 'TPM for TPCC',\n            titleTextStyle: {\n              fontSize:14\n            },\n            textStyle: {\n              fontSize:10,\n            }\n          },\n          legend: {\n            position: 'right',\n            textStyle: {fontSize: 18},\n            maxLines:8,\n            alignment:'start',\n          },\n          series: {             0: {\n                                  color: '#0052d9',\n                 pointShape:'circle',\n                 pointSize: 4,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0052d9',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            1: {\n                                  color: '#ff0000',\n                 pointShape:{ type: 'star', sides: 6,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff0000',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            2: {\n                                  color: '#2418dd',\n                 pointShape:'diamond',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#2418dd',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            3: {\n                                  color: '#ff6a00',\n                 pointShape:'star',\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#ff6a00',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            4: {\n                                  color: '#cd0d2d',\n                 pointShape:'square',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#cd0d2d',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            5: {\n                                  color: '#34a853',\n                 pointShape:{ type: 'star', sides: 5,dent:0.8 },\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#34a853',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            6: {\n                                  color: '#141e2e',\n                 pointShape:'triangle',\n                 pointSize: 5,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#141e2e',\n                     opacity: 0.8\n                   }\n                 },\n               },\n            7: {\n                                  color: '#0389d6',\n                 pointShape:{ type: 'star', sides: 4,rotation:45 },\n                 pointSize: 7,\n                 annotations: {\n                   textStyle: {\n                     fontSize: 10,\n                     color: '#0389d6',\n                     opacity: 0.8\n                   }\n                 },\n               },\n },\n          width: 1100,\n          height: 580,\n        };\n        var chart = new google.visualization.LineChart(document.getElementById('chart_div_postgresql_s04'));\n\/*\n *      set subtitle, ref:\n *          https:\/\/stackoverflow.com\/questions\/41893055\/add-subtitle-in-areachart-in-google-chart\n *\n * *\/\n        var container = document.getElementById('chart_div_postgresql_s04');\n        google.visualization.events.addListener(chart, 'ready', function () {\n          Array.prototype.forEach.call(container.getElementsByTagName('text'), function(label) {\n            if (label.innerHTML === options.title) {\n              var subtitle = label.parentNode.appendChild(label.cloneNode(true));\n              subtitle.innerHTML = '4vCPU16GB-100GB-3000iops-Multi-az-by-HammerDB\/orczhou';\n              subtitle.setAttribute('font-size', 10 );\n              subtitle.style.fontSize = \"10px\";\n              subtitle.style.fill = \"gray\";\n              \/\/subtitle.setAttribute(\"style\", \"color: green;\");\n              subtitle.setAttribute('y', parseFloat(label.getAttribute('y')) + 20);\n            }\n          });\n        });\n        chart.draw(data, options);\n      }\n    <\/script>\n    <div id=\"chart_div_postgresql_s04\" style=\"\"><\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u6d4b\u8bd5\u65b9\u6cd5\u4e0e\u91cd\u73b0<\/h3>\n\n\n\n<p>\u8fd9\u91cc\u4f7f\u7528\u5f00\u6e90\u7684 HammerDB \u8fdb\u884c\u6d4b\u8bd5\uff0c\u53ef\u4ee5\u53c2\u8003\u5982\u4e0b\u8bf4\u660e\u8fdb\u884c\u6d4b\u8bd5\u91cd\u73b0\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e3b\u8981\u7684\u6d4b\u8bd5\u53c2\u6570<\/h4>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p>\u8fd9\u91cc\u4f7f\u7528\u7684 tpcc-like \u7684\u573a\u666f\u8fdb\u884c\u6d4b\u8bd5\u3002\u6d4b\u8bd5\u6570\u636e\u5927\u5c0f\u5219\u7531 warehouses \u6570\u91cf\u51b3\u5b9a\uff0c\u5355\u4e2a\u5927\u5c0f\u7ea6\u4e3a95 MB\u3002\u8fd9\u91cc\u4f7f\u7528\u7684 warehouses \u6570\u91cf\u4e3a 80 \u4e2a\u3002\u6240\u4ee5\uff0c\u6570\u636e\u91cf\u5927\u7ea6\u4e3a 7.4 GB\u3002\u6d4b\u8bd5\u7684\u5e76\u53d1\u7528\u6237\u6570\uff0c\u5219\u5982\u4e0a\u6240\u793a\uff0c\u4ece\u6700\u5c0f 4 \u7ebf\u7a0b\u5230\u6700\u591a\u7684512\u4e2a\u7ebf\u7a0b\u3002\u5176\u4ed6\u53c2\u6570\u5305\u62ec\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>rampup \u4e3a 2\uff1b# \u9884\u70ed\u65f6\u95f4\u4e3a2\u5206\u949f <\/li>\n\n\n\n<li>duration \u4e3a5\uff1b# \u4e00\u6b21\u5e76\u53d1\u6d4b\u8bd5\u4e3a5\u5206\u949f<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"784\" height=\"1024\" src=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/11\/image-5-784x1024.png\" alt=\"\" class=\"wp-image-20732\" style=\"width:258px;height:auto\" srcset=\"https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/11\/image-5-784x1024.png 784w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/11\/image-5-230x300.png 230w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/11\/image-5-768x1003.png 768w, https:\/\/www.orczhou.com\/wp-content\/uploads\/2025\/11\/image-5.png 810w\" sizes=\"auto, (max-width: 784px) 100vw, 784px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\u6570\u636e\u5e93\u5b9e\u4f8b\u9009\u62e9<\/h4>\n\n\n\n<p>\u6570\u636e\u5e93\u7684\u89c4\u683c\u53c2\u6570\uff0c\u53ef\u4ee5\u53c2\u8003\u4e0a\u8ff0\u201c\u53c2\u6570\u8868\u201d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u89c4\u683c\u4ee3\u7801\uff0c\u53c2\u8003\u201c\u53c2\u6570\u8868\u201d\u4e2d\u7684\u201cinstance_type\u201d\u884c\uff0c\u8be5\u89c4\u683c\u4ee3\u7801\u901a\u5e38\u4ee3\u8868\u4e86\u8be5\u793a\u4f8b\u7684CPU\u548cMemory\u8d44\u6e90<\/li>\n\n\n\n<li>\u5404\u4e2a\u4e91\u5382\u5546\u7684\u78c1\u76d8\u5dee\u5f02\u5f88\u5927\uff0c\u8fd9\u91cc\u5c0f\u7ed3\u5982\u4e0b\uff1a<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table is-style-regular\" style=\"font-size:12px\"><table class=\"has-fixed-layout\"><tbody><tr><td><\/td><td>aws<\/td><td>aliyun<\/td><td>tencent<\/td><td>baidu<\/td><td>oci<\/td><td>google<\/td><td>azure<\/td><td>huawei<\/td><\/tr><tr><td>iops<\/td><td>3000<\/td><td>6800<\/td><td>NA<\/td><td>NA<\/td><td>75000<\/td><td>NA<\/td><td>2,300<\/td><td>3000<\/td><\/tr><tr><td>type<\/td><td>io1<\/td><td>PL_1<\/td><td>\u672c\u5730SSD<\/td><td>\u589e\u5f3a\u578bSSD<\/td><td>OCI_OPTIMIZED_STORAGE<\/td><td>NA<\/td><td>P20<\/td><td>CLOUDSSD<\/td><\/tr><tr><td>size<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>100<\/td><td>128<\/td><td>100<\/td><\/tr><tr><td>ref<\/td><td>NA<\/td><td><a href=\"https:\/\/help.aliyun.com\/zh\/rds\/product-overview\/primary-apsaradb-rds-instance-types?spm=a2c4g.11186623.0.0.3476576azxNXsq#section-ire-dbl-kzm\">\u53c2\u8003<\/a><\/td><td><a href=\"https:\/\/cloud.tencent.com\/document\/product\/409\/7562\">\u53c2\u8003<\/a><\/td><td><a href=\"https:\/\/cloud.baidu.com\/doc\/RDS\/s\/Wjztjsvu5\">\u53c2\u8003<\/a><\/td><td><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/postgresql\/performance-tiers.htm\">\u53c2\u8003<\/a><\/td><td><\/td><td><a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/managed-disks\/\">\u53c2\u8003<\/a><\/td><td><a href=\"https:\/\/support.huaweicloud.com\/productdesc-evs\/zh-cn_topic_0044524691.html\">\u53c2\u8003<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u8865\u5145\u8bf4\u660e\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u963f\u91cc\u4e91\u8ba1\u7b97\u516c\u5f0f\uff1a1800+50*<em>100 min{1800+50<\/em>\u5b58\u50a8\u7a7a\u95f4, 50000, \u5b9e\u4f8b\u89c4\u683c\u6700\u5927IOPS}<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u534e\u4e3a\u4e91\u8ba1\u7b97\u516c\u53f8\uff1a IOPS=min (20000, 1800 + 12 \u00d7 \u5bb9\u91cf\uff08GiB\uff09<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u817e\u8baf\u4e91\u4ec5\u672c\u5730 SSD IOPS \u5e76\u65e0\u76f8\u5173\u8bf4\u660e<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u5173\u4e8e HammerDB<\/h3>\n\n\n\n<p>HammerDB \u662f\u76ee\u524d PostgreSQL \u9886\u57df\u4f7f\u7528\u8f83\u591a\u7684\u6d4b\u8bd5\u5de5\u5177\uff0c\u8be5\u6d4b\u8bd5\u5de5\u5177\u81f4\u529b\u4e8e\u57fa\u4e8e TPC \u6807\u51c6\u6784\u5efa\u5f00\u6e90\u7684\u3001\u4fbf\u4e8e\u6267\u884c\u7684\u591a\u79cd\u6570\u636e\u5e93\u6d4b\u8bd5\u3002\u4e3b\u8981\u7684\u4e91\u5382\u5546\u4e5f\u901a\u5e38\u4f1a\u53d1\u5e03 HammerDB \u7684\u6027\u80fd\u6570\u636e\u4f5c\u4e3a\u6258\u7ba1 PostgreSQL \u7684\u57fa\u51c6\u6027\u80fd\uff0c\u4f8b\u5982\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/aws.amazon.com\/blogs\/database\/benchmark-amazon-rds-for-postgresql-single-az-db-instance-multi-az-db-instance-and-multi-az-db-cluster-deployments\/\">AWS Benchmark Amazon RDS for PostgreSQL Single-AZ DB instance, Multi-AZ DB instance, and Multi-AZ DB Cluster deployments<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/cloud.google.com\/alloydb\/docs\/benchmark-oltp-performance-alloydb\">Google Cloud: Benchmark OLTP performance on AlloyDB for PostgreSQL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/techcommunity.microsoft.com\/blog\/adforpostgresql\/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb-on-azure\/3254918#community-3254918-section08\">How to benchmark performance of Citus and Postgres with HammerDB on Azure<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u4e0d\u540c\u7684\u4e91\u5382\u5546\uff0c\u8d2d\u4e70\u76f8\u540c\u89c4\u683c\u7684 PostgreSQL \u5b9e\u4f8b\uff0c\u83b7\u5f97\u7684\u6027\u80fd\u76f8\u540c\u5417\uff1f\u672c\u6587\u4f7f\u7528 HammerDB\uff0c\u5bf9\u4e0d\u540c\u4e91\u5382\u5546\u7684\u540c\u6837\u89c4\u683c\u201c4vCPU-16GB\u201d\u8fdb\u884c\u6027\u80fd\u6d4b\u8bd5\u6765\u5c1d\u8bd5\u56de\u7b54\u4e0a\u8ff0\u95ee\u9898\u3002 HammerDB NOPM \u8be6\u7ec6\u6570\u636e Latency (Event) \u8be6\u7ec6\u6570\u636e \u5982\u4e0b\u8868\u683c\u5206\u522b\u4e3a\uff1a\u521b\u5efa\u8ba2\u5355\u7684\u5e73\u5747\u5ef6\u8fdf \u548c 95%\u5ef6\u8fdf\u6570\u636e\uff0c\u5355\u4f4d\u4e3a\u6beb\u79d2\/ms\u3002 \u53c2\u6570\u8868 \u5386\u53f2\u6d4b\u8bd5\u6570\u636e \u6d4b\u8bd5\u65b9\u6cd5\u4e0e\u91cd\u73b0 \u8fd9\u91cc\u4f7f\u7528\u5f00\u6e90\u7684 HammerDB \u8fdb\u884c\u6d4b\u8bd5\uff0c\u53ef\u4ee5\u53c2\u8003\u5982\u4e0b\u8bf4\u660e\u8fdb\u884c\u6d4b\u8bd5\u91cd\u73b0\u3002 \u4e3b\u8981\u7684\u6d4b\u8bd5\u53c2\u6570 \u8fd9\u91cc\u4f7f\u7528\u7684 tpcc-like \u7684\u573a\u666f\u8fdb\u884c\u6d4b\u8bd5\u3002\u6d4b\u8bd5\u6570\u636e\u5927\u5c0f\u5219\u7531 warehouses \u6570\u91cf\u51b3\u5b9a\uff0c\u5355\u4e2a\u5927\u5c0f\u7ea6\u4e3a95 MB\u3002\u8fd9\u91cc\u4f7f\u7528\u7684 warehouses \u6570\u91cf\u4e3a 80 \u4e2a\u3002\u6240\u4ee5\uff0c\u6570\u636e\u91cf\u5927\u7ea6\u4e3a 7.4 GB\u3002\u6d4b\u8bd5\u7684\u5e76\u53d1\u7528\u6237\u6570\uff0c\u5219\u5982\u4e0a\u6240\u793a\uff0c\u4ece\u6700\u5c0f 4 \u7ebf\u7a0b\u5230\u6700\u591a\u7684512\u4e2a\u7ebf\u7a0b\u3002\u5176\u4ed6\u53c2\u6570\u5305\u62ec\uff1a \u6570\u636e\u5e93\u5b9e\u4f8b\u9009\u62e9 \u6570\u636e\u5e93\u7684\u89c4\u683c\u53c2\u6570\uff0c\u53ef\u4ee5\u53c2\u8003\u4e0a\u8ff0\u201c\u53c2\u6570\u8868\u201d\uff1a aws aliyun tencent baidu oci google azure huawei iops 3000 6800 NA NA 75000 NA 2,300 3000 type io1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"wp-custom-template-cdb-perf-page-202507","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"class_list":["post-20720","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/pages\/20720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/comments?post=20720"}],"version-history":[{"count":28,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/pages\/20720\/revisions"}],"predecessor-version":[{"id":23600,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/pages\/20720\/revisions\/23600"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=20720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}