{"id":6343,"date":"2025-10-15T11:58:36","date_gmt":"2025-10-15T03:58:36","guid":{"rendered":"https:\/\/nullthought.net\/?p=6343"},"modified":"2025-10-16T15:53:47","modified_gmt":"2025-10-16T07:53:47","slug":"%e4%b8%bb%e6%b5%81%e6%97%b6%e5%ba%8f%e6%95%b0%e6%8d%ae%e5%ba%93%ef%bc%88tsdb%ef%bc%89%e5%8f%8a%e5%af%b9%e6%af%94%e5%88%86%e6%9e%90","status":"publish","type":"post","link":"https:\/\/nullthought.net\/?p=6343","title":{"rendered":"\u4e3b\u6d41\u65f6\u5e8f\u6570\u636e\u5e93\uff08TSDB\uff09\u53ca\u5bf9\u6bd4\u5206\u6790"},"content":{"rendered":"\n<p>\u4e3b\u6d41\u65f6\u5e8f\u6570\u636e\u5e93\uff08Time-Series Database, TSDB\uff09\u6309<strong>\u6838\u5fc3\u5b9a\u4f4d<\/strong>\u4e00\u822c\u5206\u6210\u56db\u5927\u7c7b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL\/\u5206\u6790\u578b\uff1a<strong>TimescaleDB\u3001ClickHouse\uff08\u65f6\u5e8f\u5f15\u64ce\/\u7269\u5316\u89c6\u56fe\uff09\u3001QuestDB\u3001InfluxDB 3<\/strong><\/li>\n\n\n\n<li>\u89c2\u6d4b\/\u76d1\u63a7\u578b\uff1a<strong>Prometheus\uff08\u672c\u5730 TSDB\uff09\u3001VictoriaMetrics\u3001M3DB\uff08Uber\uff09<\/strong><\/li>\n\n\n\n<li>\u5de5\u4e1a\/IoT \u573a\u666f\u578b\uff1a<strong>TDengine\u3001Apache IoTDB<\/strong><\/li>\n\n\n\n<li>\u516c\u6709\u4e91\u6258\u7ba1\u578b\uff1a<strong>Amazon Timestream\u3001Azure Data Explorer\uff08Kusto\/ADX\uff09<\/strong><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e00\u3001\u5404\u4ea7\u54c1\u8981\u70b9<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">TimescaleDB\uff08\u57fa\u4e8e PostgreSQL\uff09<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u4ee5 <strong>Hypertable<\/strong> \u505a\u65f6\u95f4\/\u7a7a\u95f4\u5206\u7247\uff1b<strong>\u8fde\u7eed\u805a\u5408\uff08Continuous Aggregates\uff09<\/strong> \u9884\u8ba1\u7b97\u5e76\u652f\u6301\u5b9e\u65f6\u8865\u6570\uff1b\u5217\u5f0f\u538b\u7f29\u3002\u9002\u5408\u9700\u8981\u6807\u51c6 SQL\/Join\/\u4e8b\u52a1\u4e00\u81f4\u6027\u7684\u573a\u666f\u3002<\/li>\n\n\n\n<li>\u5178\u578b\u4f18\u52bf\uff1a\u4e0e Postgres \u751f\u6001\u65e0\u7f1d\uff08FDW\u3001\u5de5\u5177\u94fe\uff09\uff0c\u8fc1\u79fb\u95e8\u69db\u4f4e\uff1b\u8fd0\u7ef4\u96be\u5ea6\u8f83\u4f4e\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u6781\u7aef\u9ad8\u5199\u5165\/\u9ad8\u57fa\u6570\u4e0b\u9700\u7cbe\u5fc3\u5206\u533a\u4e0e\u7b56\u7565\uff08\u4f46\u591a\u6570\u4e1a\u52a1\u8db3\u591f\u7528\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">ClickHouse\uff08OLAP\uff09\u7528\u4e8e\u65f6\u5e8f<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u505a\u6cd5\uff1a\u901a\u8fc7 <strong>AggregatingMergeTree<\/strong>\u3001<strong>\u7269\u5316\u89c6\u56fe<\/strong> \u6216 <strong>TimeSeries \u8868\u5f15\u64ce<\/strong> \u5b9e\u73b0\u5927\u89c4\u6a21\u65f6\u5e8f\u9884\u805a\u5408\u4e0e\u67e5\u8be2\u52a0\u901f\u3002\u9002\u5408\u65e5\u5fd7\/\u6307\u6807\u7edf\u4e00\u5206\u6790\u4e0e\u590d\u6742\u591a\u7ef4\u62a5\u8868\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u6781\u5f3a\u7684\u805a\u5408\/\u626b\u63cf\u6027\u80fd\u3001\u5b9e\u65f6\/\u8fd1\u5b9e\u65f6\u5206\u6790\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u5efa\u6a21\u4e0e\u7269\u5316\u94fe\u8def\u9700\u8981\u6570\u636e\u5de5\u7a0b\u5b9e\u8df5\uff1b\u5199\u5165\u4e71\u5e8f\u4e0e\u53bb\u91cd\u7b56\u7565\u8981\u8bbe\u8ba1\u597d\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">QuestDB<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u4e13\u6ce8<strong>\u8d85\u9ad8\u541e\u5410\u5199\u5165 + \u4f4e\u5ef6\u8fdf SQL<\/strong>\uff0c\u5f15\u64ce\u96f6 GC\uff08Java\/C++\uff09\uff0c\u5206\u5c42\u5b58\u50a8\uff08WAL\u2192\u672c\u5730\u2192\u5bf9\u8c61\u5b58\u50a8 Parquet\uff09\u3002\u5728\u8d44\u672c\u5e02\u573a\u7b49\u4f4e\u5ef6\u8fdf\u573a\u666f\u8868\u73b0\u7a81\u51fa\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u6807\u51c6 SQL\uff08\u5e26\u65f6\u5e8f\u6269\u5c55\uff09\u3001\u6781\u7b80\u90e8\u7f72\u3001\u5bf9\u4e71\u5e8f\u5199\u5165\u4f18\u5316\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u751f\u6001\u76f8\u5bf9 Timescale\/ClickHouse \u8f83\u65b0\uff0c\u529f\u80fd\u53d6\u820d\u504f\u5b9e\u65f6\u4ea4\u6613\/\u76d1\u63a7\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">InfluxDB 3\uff08IOx \u91cd\u6784\uff09<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u6838\u5fc3\u5f15\u64ce\u91cd\u5199\u4e3a <strong>Rust + Apache Arrow + DataFusion + Parquet\uff08FDAP \u6808\uff09<\/strong>\uff0c\u7edf\u4e00\u4ee5 DataFusion \u6267\u884c\u8ba1\u5212\u9a71\u52a8\u8bfb\u5199\u4e0e\u538b\u5b9e\uff1bSQL\/InfluxQL\/Flux \u7edf\u4e00\u5230\u540c\u4e00\u6267\u884c\u5c42\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u5bf9\u8c61\u5b58\u50a8\u53cb\u597d\u3001\u8de8\u751f\u6001\u4e92\u64cd\u4f5c\u6027\u5f3a\uff08Arrow\/Parquet\uff09\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u4ece v2\u2192v3 \u8de8\u4ee3\u5dee\u5f02\u8f83\u5927\uff0c\u529f\u80fd\/\u751f\u6001\u9700\u4ee5 v3 \u6587\u6863\u4e3a\u51c6\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">Prometheus\uff08\u5185\u7f6e TSDB\uff09<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1aCNCF \u4e8b\u5b9e\u6807\u51c6\u7684\u76d1\u63a7\u7cfb\u7edf\uff1b\u672c\u5730 TSDB \u4ee5 <strong>WAL + \u5757\u6587\u4ef6<\/strong> \u5b58\u50a8\uff0c\u914d\u5408\u8fdc\u7aef\u5199\u6269\u5c55\u5230\u591a\u79df\u6237\/\u957f\u4fdd\u7559\u65b9\u6848\uff08Cortex\/Thanos\/Victoria \u7b49\uff09\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u6307\u6807\u91c7\u96c6\u4e0e\u544a\u8b66\u95ed\u73af\u3001\u793e\u533a\u751f\u6001\u6700\u5927\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a<strong>\u5355\u673a<\/strong>\u4e3a\u4e3b\uff0c\u957f\u65f6\u4fdd\u7559\/\u591a\u533a\u57df\u5f80\u5f80\u501f\u52a9\u8fdc\u7aef\u5b58\u50a8\u6216\u5916\u90e8 TSDB\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">VictoriaMetrics<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u4e3a\u76d1\u63a7\/\u6307\u6807\u4f18\u5316\u7684 TSDB\uff0c<strong>\u5355\u673a\u5373\u53ef\u9876\u66ff\u4e2d\u7b49\u89c4\u6a21\u96c6\u7fa4<\/strong>\uff1b\u4ea6\u6709\u96c6\u7fa4\u7248\u3002\u5f3a\u8c03\u9ad8\u57fa\u6570\u4e0e\u4f4e\u8d44\u6e90\u5360\u7528\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u90e8\u7f72\u7b80\u6d01\u3001\u6027\u4ef7\u6bd4\u6781\u9ad8\uff0c\u517c\u5bb9 PromQL\/\u8fdc\u7aef\u5199\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u6781\u7aef\u8d85\u5927\u89c4\u6a21\/\u8d85\u9ad8\u5e76\u53d1\u4e0b\u9700\u6309\u5b98\u65b9\u5efa\u8bae\u9009\u62e9\u5355\u673a\u6216\u96c6\u7fa4\u6a21\u5f0f\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">M3DB\uff08Uber\uff09<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u4e3a<strong>\u5927\u89c4\u6a21\u957f\u4fdd\u7559\u6307\u6807<\/strong>\u6253\u9020\u7684\u5206\u5e03\u5f0f TSDB\uff0c\u517c\u5bb9 Prometheus \u751f\u6001\uff1b\u4f7f\u7528 <strong>M3TSZ<\/strong> \u7b49\u538b\u7f29\u7b97\u6cd5\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u6c34\u5e73\u6269\u5c55\u3001\u591a\u79df\u6237\u3001\u4e0e Prometheus \u8fdc\u7aef\u5199\u914d\u5408\u6210\u719f\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u7ec4\u4ef6\u591a\u3001\u8fd0\u7ef4\u590d\u6742\u5ea6\u8f83\u9ad8\uff0c\u9002\u5408\u5927\u516c\u53f8\u5e73\u53f0\u578b\u56e2\u961f\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">TDengine<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u9762\u5411\u5de5\u4e1a IoT \u7684 TSDB\/\u6d41\u5f0f\u8ba1\u7b97\u4e00\u4f53\u5316\u5e73\u53f0\uff1b<strong>snode<\/strong> \u6d41\u5904\u7406\u3001\u5185\u7f6e\u8ba2\u9605\/\u8ba1\u7b97\u7ba1\u9053\uff0c\u5f00\u6e90\u542b\u96c6\u7fa4\u80fd\u529b\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u5199\u5165\u4e0e\u538b\u7f29\u9488\u5bf9\u65f6\u5e8f\u6df1\u5ea6\u4f18\u5316\uff1b\u7aef\u4e91\u534f\u540c\/\u6d41\u6c34\u7ebf\u7b97\u5b50\u53cb\u597d\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1aSQL\/\u751f\u6001\u4e0e\u901a\u7528\u6570\u4ed3\u4e0d\u540c\uff0c\u9700\u8981\u6309\u5176\u8303\u5f0f\u5efa\u6a21\u4e0e\u8fd0\u7ef4\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">Apache IoTDB<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a<strong>\u5de5\u4e1a\u7269\u8054\u7f51<\/strong>\u53d6\u5411\uff0c\u8fb9\u4e91\u534f\u540c\u3001\u8d85\u9ad8\u538b\u7f29\u3001\u9762\u5411\u8bbe\u5907\/\u70b9\u4f4d\u7684\u65f6\u5e8f\u5143\u6570\u636e\u7ba1\u7406\uff1b\u5206\u5e03\u5f0f\u5f15\u64ce\u542b\u7c7b LSM \u5199\u5165\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u9762\u5411\u8bbe\u5907\u5c42\u62bd\u8c61\u3001\u534f\u8bae\u9002\u914d\u4e30\u5bcc\uff0c\u9002\u5408\u6d77\u91cf\u70b9\u4f4d\u4e0e\u8fb9\u7f18\u573a\u666f\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u901a\u7528 BI\/SQL \u751f\u6001\u5bf9\u63a5\u9700\u8981\u7f51\u5173\u6216\u4e2d\u95f4\u5c42\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">Amazon Timestream\uff08\u6258\u7ba1\uff09<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a**\u5185\u5b58\u5c42 + \u78c1\u76d8\u5c42\uff08\u78c1\u6027\u5b58\u50a8\uff09**\u5206\u5c42\u4e0e\u751f\u547d\u5468\u671f\u7b56\u7565\uff0c\u514d\u8fd0\u7ef4\u3001\u81ea\u52a8\u591a AZ\u3002<\/li>\n\n\n\n<li>\u9002\u7528\uff1a\u5168\u6258\u7ba1\/Serverless\uff0c\u5199\u591a\u8bfb\u5feb\u7684\u7269\u8054\u7f51\/\u5e94\u7528\u9065\u6d4b\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u4e91\u5382\u5546\u9501\u5b9a\uff0c\u6210\u672c\u4e0e\u67e5\u8be2\u7279\u6027\u9700\u7ed3\u5408\u7528\u91cf\u8bc4\u4f30\u3002<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">Azure Data Explorer \/ Kusto\uff08ADX\uff09<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6982\u5ff5\uff1a\u57fa\u4e8e <strong>KQL<\/strong> \u7684\u5927\u89c4\u6a21\u9065\u6d4b\/\u65e5\u5fd7\/\u65f6\u5e8f\u5206\u6790\u670d\u52a1\uff0c\u5185\u7f6e<strong>make-series<\/strong>\u3001\u5f02\u5e38\u68c0\u6d4b\u3001\u5b63\u8282\u6027\/\u8d8b\u52bf\u5206\u89e3\u7b49\u51fd\u6570\u65cf\uff1b\u5fae\u8f6f\u5b98\u65b9\u4e3b\u63a8\u66ff\u4ee3\u5df2\u9000\u5f79\u7684 TSI\u3002<\/li>\n\n\n\n<li>\u4f18\u52bf\uff1a\u67e5\u8be2\u8bed\u8a00\u5bf9\u65f6\u5e8f\u5206\u6790\u4e00\u7b49\u516c\u6c11\uff0c\u4ea4\u4e92\u5f0f\/\u8fd1\u5b9e\u65f6\u5206\u6790\u5f3a\u3002<\/li>\n\n\n\n<li>\u6ce8\u610f\u70b9\uff1a\u5b66\u4e60 KQL\uff1b\u6700\u4f73\u5728 Azure \u4f53\u7cfb\u5185\u4f7f\u7528\u3002<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e8c\u3001\u6a2a\u5411\u5bf9\u6bd4\uff08\u7cbe\u8981\uff09<\/h4>\n\n\n\n<figure class=\"wp-block-table has-small-font-size\"><table class=\"has-fixed-layout\"><thead><tr><th>\u7ef4\u5ea6<\/th><th>TimescaleDB<\/th><th>ClickHouse(\u65f6\u5e8f)<\/th><th>QuestDB<\/th><th>InfluxDB 3<\/th><th>Prometheus<\/th><th>VictoriaMetrics<\/th><th>M3DB<\/th><th>TDengine<\/th><th>Apache IoTDB<\/th><th>Timestream<\/th><th>ADX\/Kusto<\/th><\/tr><\/thead><tbody><tr><td>\u4e3b\u8981\u5b9a\u4f4d<\/td><td>SQL\/OLTP+\u65f6\u5e8f<\/td><td>OLAP\/\u65f6\u5e8f\u5206\u6790<\/td><td>\u4f4e\u5ef6\u8fdfSQL&amp;\u9ad8\u541e\u5410<\/td><td>Arrow\/\u5bf9\u8c61\u5b58\u50a8\u53cb\u597d<\/td><td>\u76d1\u63a7\u91c7\u96c6\/\u544a\u8b66<\/td><td>\u76d1\u63a7\u957f\u4fdd\u7559\/\u9ad8\u6027\u4ef7\u6bd4<\/td><td>\u5927\u89c4\u6a21\u591a\u79df\u6237\u6307\u6807<\/td><td>\u5de5\u4e1aIoT\u4e00\u4f53\u5316<\/td><td>\u5de5\u4e1aIoT\/\u8fb9\u4e91<\/td><td>\u6258\u7ba1IoT\/\u9065\u6d4b<\/td><td>\u6258\u7ba1\u65e5\u5fd7\/\u9065\u6d4b\/\u65f6\u5e8f<\/td><\/tr><tr><td>\u8bed\u8a00\/\u63a5\u53e3<\/td><td>\u6807\u51c6 SQL<\/td><td>SQL<\/td><td>SQL<\/td><td>SQL\/InfluxQL\/Flux<\/td><td>PromQL<\/td><td>PromQL<\/td><td>PromQL\/Graphite<\/td><td>SQL \u7c7b\/\u51fd\u6570<\/td><td>\u4e13\u7528\u67e5\u8be2\/\u591a\u534f\u8bae<\/td><td>SQL \u7c7b\/\u51fd\u6570<\/td><td>KQL<\/td><\/tr><tr><td>\u9884\u805a\u5408<\/td><td>\u8fde\u7eed\u805a\u5408<\/td><td>\u7269\u5316\u89c6\u56fe\/\u805a\u5408\u6811<\/td><td>SQL+\u7d22\u5f15<\/td><td>DataFusion \u6267\u884c<\/td><td>\u5f55\u5165\u5373\u805a\u5408\u5c11<\/td><td>TS \u4f18\u5316<\/td><td>\u805a\u5408+\u4fdd\u7559<\/td><td>\u6d41\u8ba1\u7b97\u5185\u5efa<\/td><td>\u5185\u7f6e\u7b97\u5b50<\/td><td>\u5206\u5c42+\u8ba1\u5212\u67e5\u8be2<\/td><td>make-series \u7b49<\/td><\/tr><tr><td>\u5199\u5165\u573a\u666f<\/td><td>\u4e2d\u9ad8<\/td><td>\u6781\u9ad8<\/td><td>\u6781\u9ad8<\/td><td>\u9ad8<\/td><td>\u4e2d\uff08\u5355\u673a\uff09<\/td><td>\u9ad8\uff08\u5355\u673a\/\u96c6\u7fa4\uff09<\/td><td>\u6781\u9ad8\uff08\u5206\u5e03\u5f0f\uff09<\/td><td>\u9ad8<\/td><td>\u9ad8<\/td><td>\u9ad8<\/td><td>\u9ad8<\/td><\/tr><tr><td>\u9ad8\u57fa\u6570<\/td><td>\u4e2d<\/td><td>\u9ad8<\/td><td>\u9ad8<\/td><td>\u9ad8<\/td><td>\u53d7\u9650\uff08\u9700\u5206\u644a\uff09<\/td><td>\u9ad8\uff08\u5f3a\u8c03\uff09<\/td><td>\u9ad8<\/td><td>\u4e2d-\u9ad8<\/td><td>\u4e2d-\u9ad8<\/td><td>\u9ad8<\/td><td>\u9ad8<\/td><\/tr><tr><td>\u8fd0\u7ef4\u590d\u6742\u5ea6<\/td><td>\u4f4e-\u4e2d<\/td><td>\u4e2d<\/td><td>\u4f4e<\/td><td>\u4e2d<\/td><td>\u4f4e<\/td><td>\u4f4e<\/td><td>\u9ad8<\/td><td>\u4e2d<\/td><td>\u4e2d<\/td><td>\u4f4e<\/td><td>\u4f4e<\/td><\/tr><tr><td>\u5178\u578b\u573a\u666f<\/td><td>BI\/\u62a5\u8868\/\u98ce\u63a7<\/td><td>\u6d77\u91cf\u65e5\u5fd7\/\u6307\u6807\u5206\u6790<\/td><td>\u4ea4\u6613\/\u884c\u60c5\/\u4f4e\u5ef6\u8fdf<\/td><td>\u7edf\u4e00\u6e56\u4ed3\/IoT<\/td><td>\u5e94\u7528\u76d1\u63a7<\/td><td>\u5927\u89c4\u6a21\u76d1\u63a7\u5b58\u50a8<\/td><td>\u5927\u5382\u7ea7\u76d1\u63a7\u5e73\u53f0<\/td><td>\u5de5\u4e1a IoT \u5e73\u53f0<\/td><td>\u5de5\u4e1a\u8bbe\u5907\/\u70b9\u4f4d<\/td><td>\u514d\u8fd0\u7ef4 IoT<\/td><td>Azure \u4f53\u7cfb\u5206\u6790<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\uff08\u8868\u5185\u6982\u62ec\u57fa\u4e8e\u5b98\u65b9\u6587\u6863\u4e0e\u5b9e\u8df5\u62a5\u9053\uff0c\u7ec6\u8282\u968f\u89c4\u6a21\/\u5efa\u6a21\u800c\u53d8\u3002\u53c2\u8003\u6587\u6863\u89c1\u4e0b\u65b9\u5f15\u7528\u3002\uff09<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e09\u3001\u6027\u80fd\u4e0e\u57fa\u6570\uff08cardinality\uff09\u8981\u70b9<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Prometheus \u5bb6\u65cf<\/strong>\uff1a\u5355\u673a TSDB \u7b80\u6d01\u9ad8\u6548\uff0c\u4f46<strong>\u9ad8\u57fa\u6570<\/strong>\uff08\u6807\u7b7e\u7ec4\u5408\u7206\u70b8\uff09\u4f1a\u5403\u5185\u5b58\u4e0e\u67e5\u8be2\u6027\u80fd\uff0c\u5e38\u7528\u505a\u6cd5\u662f<strong>\u8fdc\u7aef\u5199<\/strong>\u5230 VictoriaMetrics\/M3 \u7b49\u8fdb\u884c\u957f\u4fdd\u7559\u4e0e\u964d\u672c\u3002<\/li>\n\n\n\n<li><strong>OLAP\/SQL \u7cfb<\/strong>\uff08ClickHouse\/QuestDB\/InfluxDB3\uff09\uff1a\u901a\u8fc7\u5217\u5f0f+\u538b\u7f29+\u9884\u805a\u5408\uff08\u7269\u5316\u89c6\u56fe\/Parquet \u538b\u5b9e\uff09\u6765\u7ef4\u6301\u626b\u63cf\u6548\u7387\uff1b\u8bbe\u8ba1\u597d<strong>\u5206\u533a\u952e\/\u6392\u5e8f\u952e<\/strong>\u662f\u5173\u952e\u3002<\/li>\n\n\n\n<li><strong>\u5de5\u4e1a IoT<\/strong>\uff08TDengine\/IoTDB\uff09\uff1a\u5bf9<strong>\u4e71\u5e8f\u5199\u5165\u3001\u70b9\u4f4d\u5143\u6570\u636e\u3001\u6781\u9ad8\u538b\u7f29\u6bd4<\/strong>\u505a\u4e86\u4e13\u95e8\u4f18\u5316\uff0c\u5e76\u5185\u7f6e<strong>\u6d41\u5904\u7406\/\u8ba1\u7b97<\/strong>\uff0c\u66f4\u8d34\u8fd1\u8fb9\u2014\u4e91\u4e00\u4f53\u7684\u5de5\u7a0b\u843d\u5730\u3002<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u56db\u3001\u9009\u578b\u5efa\u8bae\uff08\u6309\u5e94\u7528\u753b\u50cf\uff09<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u5e94\u7528\u76d1\u63a7\/\u544a\u8b66\u4e3a\u4e3b\uff08PromQL \u751f\u6001\uff09\uff1a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5355\u96c6\u7fa4\u4e2d\u7b49\u89c4\u6a21 \u2192 <strong>VictoriaMetrics\uff08\u5355\u673a\u6216 HA\uff09<\/strong>\uff1b<\/li>\n\n\n\n<li>\u8d85\u5927\u89c4\u6a21\/\u591a\u79df\u6237\/\u8d85\u957f\u4fdd\u7559 \u2192 <strong>M3DB<\/strong> \u6216 <strong>VictoriaMetrics \u96c6\u7fa4<\/strong>\u3002<\/li>\n<\/ul>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\u9700\u8981\u6807\u51c6 SQL\u3001\u4e0e\u73b0\u6709 Postgres\/BI \u6df1\u5ea6\u878d\u5408\uff1a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4ee5\u62a5\u8868\/\u98ce\u63a7\/\u591a\u8868 Join \u4e3a\u4e3b \u2192 <strong>TimescaleDB<\/strong>\uff1b<\/li>\n\n\n\n<li>\u6d77\u91cf\u65e5\u5fd7+\u590d\u6742\u805a\u5408 \u2192 <strong>ClickHouse\uff08\u7269\u5316\u89c6\u56fe\/TimeSeries \u5f15\u64ce\uff09<\/strong>\u3002<\/li>\n<\/ul>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\u8d85\u9ad8\u541e\u5410\u4e0e\u4f4e\u5ef6\u8fdf\uff08\u4ea4\u6613\/\u884c\u60c5\/\u98ce\u63a7\u56de\u653e\uff09\uff1a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4f18\u5148\u8003\u8651 <strong>QuestDB<\/strong>\uff0c\u5176\u5728\u4ea4\u6613\u6240\/\u64ae\u5408\u4fa7\u6709\u6210\u529f\u6848\u4f8b\uff1b\u4e5f\u53ef\u8bc4\u4f30 <strong>ClickHouse<\/strong> \u7684\u5b9e\u65f6\u94fe\u8def\u3002<\/li>\n<\/ul>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>\u5bf9\u8c61\u5b58\u50a8\u53cb\u597d + \u8de8\u751f\u6001\uff08Arrow\/Parquet\uff09\u4e92\u901a\uff1a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>InfluxDB 3\uff08IOx\uff09<\/strong>\uff1a\u7edf\u4e00 DataFusion \u8ba1\u5212\uff0c\u5229\u4e8e\u6e56\u4ed3\u4e00\u4f53\u4e0e\u4e0b\u6e38\u5de5\u5177\u534f\u4f5c\u3002<\/li>\n<\/ul>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li><strong>\u5de5\u4e1a IoT\/\u8fb9\u4e91\u534f\u540c\/\u5185\u7f6e\u6d41\u5904\u7406\uff1a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>TDengine<\/strong>\uff08snode\/\u6d41\u5f0f\u7b97\u5b50\uff09\u6216 <strong>Apache IoTDB<\/strong>\uff08\u8bbe\u5907\u5143\u6570\u636e\/\u538b\u7f29\/\u8fb9\u4e91\uff09\uff1b\u9700\u8981\u7aef\u4fa7\/\u534f\u8bae\u9002\u914d\u4e0e\u5de5\u7a0b\u5316\u80fd\u529b\u65f6\u66f4\u6709\u4f18\u52bf\u3002<\/li>\n<\/ul>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li><strong>\u5168\u6258\u7ba1\/\u5c11\u8fd0\u7ef4\uff1a<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Amazon Timestream<\/strong>\uff08\u5185\u5b58\u5c42+\u78c1\u76d8\u5c42\u5206\u7ea7\u4e0e\u751f\u547d\u5468\u671f\u7b56\u7565\uff09\uff1b<\/li>\n\n\n\n<li><strong>Azure Data Explorer<\/strong>\uff08KQL \u539f\u751f\u65f6\u5e8f\u51fd\u6570\uff0cTSI \u5df2\u9000\u5f79\u8f6c\u5411 ADX\uff09\u3002<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u4e94\u3001\u5b9e\u8df5\u843d\u5730\u7684\u4e09\u6761\u901a\u7528\u539f\u5219<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5efa\u6a21\u5148\u884c<\/strong>\uff1a\u9009\u62e9\u5408\u9002\u7684<strong>\u65f6\u95f4\u5206\u533a\u3001\u4e3b\u952e\/\u6392\u5e8f\u952e\u3001\u6807\u7b7e\u8bbe\u8ba1<\/strong>\uff0c\u907f\u514d\u9ad8\u57fa\u6570\u7206\u70b8\uff1bPrometheus \u6307\u6807\u5e94\u89c4\u8303\u7ef4\u5ea6\u5e76\u63a7\u5236 label cardinality\u3002<\/li>\n\n\n\n<li><strong>\u51b7\u70ed\u5206\u5c42\/\u9884\u805a\u5408<\/strong>\uff1a\u5bf9\u957f\u5468\u671f\u770b\u677f\u7528 <strong>\u8fde\u7eed\u805a\u5408\/\u7269\u5316\u89c6\u56fe<\/strong>\uff1b\u70ed\u6570\u636e\u4fdd\u7559\u5728\u5185\u5b58\u6216\u9ad8\u901f\u5c42\uff0c\u51b7\u6570\u636e\u4e0b\u6c89\u5230\u5217\u5f0f\/\u5bf9\u8c61\u5b58\u50a8\uff08Parquet\uff09\u3002<\/li>\n\n\n\n<li><strong>\u89c2\u6d4b\u4e0e\u518d\u5e73\u8861<\/strong>\uff1a\u76d1\u63a7\u5199\u5165\u4e71\u5e8f\u3001\u538b\u7f29\u6bd4\u3001\u67e5\u8be2\u70ed\u70b9\uff1b\u5728 VictoriaMetrics\/M3\/ClickHouse \u4e0a\u6309\u5b98\u65b9\u6307\u5bfc\u505a<strong>\u5206\u7247\u4e0e\u538b\u5b9e<\/strong>\u8c03\u4f18\u3002<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">\u516d\u3001\u8fdb\u4e00\u6b65\u8d44\u6599\uff08\u6838\u5fc3\u6765\u6e90\uff09<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>InfluxDB 3 \u7684 FDAP\/Arrow\/DataFusion \u67b6\u6784\u4e0e\u91cd\u6784\u76ee\u6807\u3002<a href=\"https:\/\/www.infoq.com\/articles\/timeseries-db-rust\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">InfoQ+2 InfluxData+2<\/a><\/li>\n\n\n\n<li>TimescaleDB \u8fde\u7eed\u805a\u5408\/\u538b\u7f29\u4e0e\u5b9e\u6218\u7ecf\u9a8c\u3002<a href=\"https:\/\/docs.timescale.com\/use-timescale\/latest\/continuous-aggregates\/?__hsfp=150561067&amp;__hssc=231067136.8.1750291200198&amp;__hstc=231067136.73bd3bee6fa385653ecd7c9674ba06f0.1750291200195.1750291200196.1750291200197.1&amp;utm_campaign=dev-2025&amp;utm_content=postgres-partitioning-hypertables%2F&amp;utm_medium=referral&amp;utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">docs.timescale.com+2 tigerdata.com+2<\/a><\/li>\n\n\n\n<li>ClickHouse \u7684 AggregatingMergeTree\u3001\u7269\u5316\u89c6\u56fe\u4e0e TimeSeries \u8868\u5f15\u64ce\u3002<a href=\"https:\/\/clickhouse.com\/docs\/engines\/table-engines\/mergetree-family\/aggregatingmergetree?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">ClickHouse+2 ClickHouse+2<\/a><\/li>\n\n\n\n<li>Prometheus \u5b58\u50a8\u6a21\u578b\uff08WAL\/\u5757\uff09\u4e0e\u8fdc\u7aef\u5199\u751f\u6001\uff08Cortex\uff09\u3002<a href=\"https:\/\/prometheus.io\/docs\/prometheus\/latest\/storage\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">Prometheus+1<\/a><\/li>\n\n\n\n<li>VictoriaMetrics \u67b6\u6784\u4e0e\u9ad8\u57fa\u6570\u6ce8\u610f\u4e8b\u9879\u3002<a href=\"https:\/\/docs.victoriametrics.com\/victoriametrics\/single-server-victoriametrics\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">docs.victoriametrics.com+2 docs.victoriametrics.com+2<\/a><\/li>\n\n\n\n<li>M3DB \u67b6\u6784\/\u538b\u7f29\uff08M3TSZ\uff09\u4e0e Uber \u5b9e\u8df5\u3002<a href=\"https:\/\/m3db.io\/docs\/architecture\/m3db\/overview\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">M3+2 M3+2<\/a><\/li>\n\n\n\n<li>TDengine \u6d41\u5904\u7406\u67b6\u6784\u4e0e\u5de5\u4e1a IoT \u5b9a\u4f4d\u3002<a href=\"https:\/\/docs.tdengine.com\/inside-tdengine\/architecture\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">docs.tdengine.com+2 docs.tdengine.com+2<\/a><\/li>\n\n\n\n<li>Apache IoTDB \u5de5\u4e1a\u573a\u666f\u4e0e\u5206\u5e03\u5f0f\u5f15\u64ce\u3002<a href=\"https:\/\/iotdb.apache.org\/?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">IoTDB Website+1<\/a><\/li>\n\n\n\n<li>Amazon Timestream \u5206\u5c42\u5b58\u50a8\u4e0e\u751f\u547d\u5468\u671f\u7b56\u7565\u3002<a href=\"https:\/\/docs.aws.amazon.com\/timestream\/latest\/developerguide\/storage.html?utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">AWS \u6587\u6863+1<\/a><\/li>\n\n\n\n<li>Azure Data Explorer \/ KQL \u7684\u65f6\u5e8f\u5206\u6790\u51fd\u6570\u4e0e TSI \u9000\u5f79\u52a8\u5411\u3002<a href=\"https:\/\/learn.microsoft.com\/en-us\/kusto\/query\/time-series-analysis?view=microsoft-fabric&amp;utm_source=chatgpt.com\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Learn+2 Microsoft Learn+2<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u4e3b\u6d41\u65f6\u5e8f\u6570\u636e\u5e93\uff08Time-Series Database, TSDB\uff09\u6309\u6838\u5fc3\u5b9a\u4f4d\u4e00\u822c\u5206\u6210\u56db\u5927\u7c7b\uff1a \u4e00\u3001\u5404\u4ea7\u54c1\u8981 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[3,8],"tags":[40],"class_list":["post-6343","post","type-post","status-publish","format-standard","hentry","category-it","category-tech","tag-iot"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"NullThought","author_link":"https:\/\/nullthought.net\/?author=1"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/nullthought.net\/?cat=3\" rel=\"category\">IT<\/a> <a href=\"https:\/\/nullthought.net\/?cat=8\" rel=\"category\">Tech<\/a>","rttpg_excerpt":"\u4e3b\u6d41\u65f6\u5e8f\u6570\u636e\u5e93\uff08Time-Series Database, TSDB\uff09\u6309\u6838\u5fc3\u5b9a\u4f4d\u4e00\u822c\u5206\u6210\u56db\u5927\u7c7b\uff1a \u4e00\u3001\u5404\u4ea7\u54c1\u8981&hellip;","_links":{"self":[{"href":"https:\/\/nullthought.net\/index.php?rest_route=\/wp\/v2\/posts\/6343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nullthought.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nullthought.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nullthought.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nullthought.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6343"}],"version-history":[{"count":2,"href":"https:\/\/nullthought.net\/index.php?rest_route=\/wp\/v2\/posts\/6343\/revisions"}],"predecessor-version":[{"id":6390,"href":"https:\/\/nullthought.net\/index.php?rest_route=\/wp\/v2\/posts\/6343\/revisions\/6390"}],"wp:attachment":[{"href":"https:\/\/nullthought.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nullthought.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nullthought.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}