先用官方文档中推荐的方法。aaakylin-pc:~$ curl https://install.duckdb.org | sh % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 curl: (60) SSL certificate problem: certificate is not yet valid More details here: https://curl.haxx.se/docs/sslcerts.html curl failed to verify the legitimacy of the server and therefore could not establish a secure connection to it. To learn more about this situation and how to fix it, please visit the web page mentioned above.按照https://curl.haxx.se/docs/sslcerts.html的提示添加了-k选项忽略第一步通过了第二步仍然报错。aaakylin-pc:~$ curl -k https://install.duckdb.org | sh % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 4054 100 4054 0 0 4791 0 --:--:-- --:--:-- --:--:-- 4786 *** DuckDB Linux/MacOS installation script, version *** .;odxdl, .xXXXXXXXXKc 0XXXXXXXXXXXd cooo: ,XXXXXXXXXXXXK OXXXXd 0XXXXXXXXXXXo cooo: .xXXXXXXXXKc .;odxdl, curl: (60) SSL certificate problem: certificate is not yet valid More details here: https://curl.haxx.se/docs/sslcerts.html curl failed to verify the legitimacy of the server and therefore could not establish a secure connection to it. To learn more about this situation and how to fix it, please visit the web page mentioned above.只好直接下载二进制文件了。结果还提示证书问题。用–no-check-certificate忽略。aaakylin-pc:~$ wget https://install.duckdb.org/v1.4.4/duckdb_cli-linux-arm64.zip --2026-01-26 11:23:47-- https://install.duckdb.org/v1.4.4/duckdb_cli-linux-arm64.zip 错误: 无法验证 install.duckdb.org 的由 “CNWE1,OGoogle Trust Services,CUS” 颁发的证书: 颁发的证书还未生效。 要以不安全的方式连接至 install.duckdb.org使用“--no-check-certificate”。 aaakylin-pc:~$ wget https://install.duckdb.org/v1.4.4/duckdb_cli-linux-arm64.zip --no-check-certificate --2026-01-26 11:24:06-- https://install.duckdb.org/v1.4.4/duckdb_cli-linux-arm64.zip 警告: 无法验证 install.duckdb.org 的由 “CNWE1,OGoogle Trust Services,CUS” 颁发的证书: 颁发的证书还未生效。 已发出 Proxy 请求正在等待回应... 200 OK 长度17509597 (17M) [application/octet-stream] 正在保存至: “duckdb_cli-linux-arm64.zip” duckdb_cli-linux-arm64.zip 100%[] 16.70M 5.92MB/s 用时 2.8s 2026-01-26 11:24:10 (5.92 MB/s) - 已保存 “duckdb_cli-linux-arm64.zip” [17509597/17509597])解压后执行我的基准测试SQL。并查看cpu信息。aaakylin-pc:~$ unzip duck*zip Archive: duckdb_cli-linux-arm64.zip inflating: duckdb aaakylin-pc:~$ ./duckdb DuckDB v1.4.4 (Andium) 6ddac802ff Enter .help for usage hints. Connected to a transient in-memory database. Use .open FILENAME to reopen on a persistent database. D .timer on D select sum(i) from range(1,10000001)t(i) group by round(log(i)); ┌────────────────┐ │ sum(i) │ │ int128 │ ├────────────────┤ │ 6 │ │ 49590 │ │ 4950617 │ │ 4949999577625 │ │ 494990550 │ │ 490 │ │ 49499924625 │ │ 45000005506497 │ └────────────────┘ Run Time (s): real 0.271 user 0.270474 sys 0.004906 D aaakylin-pc:~$ lscpu 架构 aarch64 CPU 运行模式 32-bit, 64-bit 字节序 Little Endian CPU: 12 在线 CPU 列表 0-11 每个核的线程数 1 每个座的核数 2 座 3 厂商 ID ARM 型号 2 型号名称 HUAWEI Kirin 9000C 步进 r1p2 CPU 最大 MHz 2189.0000 CPU 最小 MHz 335.0000 BogoMIPS 3.84 Vulnerability Itlb multihit: Not affected Vulnerability L1tf: Not affected Vulnerability Mds: Not affected Vulnerability Meltdown: Not affected Vulnerability Mmio stale data: Not affected Vulnerability Retbleed: Not affected Vulnerability Spec store bypass: Mitigation; Speculative Store Bypass disabled via prctl Vulnerability Spectre v1: Mitigation; __user pointer sanitization Vulnerability Spectre v2: Mitigation; CSV2, but not BHB Vulnerability Srbds: Not affected Vulnerability Tsx async abort: Not affected 标记 fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimd dp sha512 sve asimdfhm dit uscat ilrcpc flagm ssbs sb dcpodp flagm2 frint svei8mm i8mm为了便于安装插件先安装httpfs插件。并新建代理服务器的SECRET。wget http://extensions.duckdb.org/v1.4.4/linux_arm64/httpfs.duckdb_extension.gz D install ./httpfs.duckdb_extension.gz; D CREATE persistent SECRET http_proxy ( TYPE http, HTTP_PROXY http://proxy.aaa:8080 ); ┌─────────┐ │ Success │ │ boolean │ ├─────────┤ │ true │ └─────────┘ D load tpch; IO Error: Extension /home/aaa/.duckdb/extensions/v1.4.4/linux_arm64/tpch.duckdb_extension not found. Extension tpch is an existing extension. Install it first using INSTALL tpch. D install tpch; IO Error: Failed to download extension tpch at URL http://extensions.duckdb.org/v1.4.4/linux_arm64/tpch.duckdb_extension.gz Extension tpch is an existing extension. For more info, visit https://duckdb.org/docs/stable/extensions/troubleshooting?versionv1.4.4platformlinux_arm64extensiontpch (ERROR Failed to read connection)奇怪还是不能在线安装tpch插件。原来忘记了加载httpfs插件加载后就能在线安装tpch插件。D load httpfs; D install tpch; 100% ▕██████████████████████████████████████▏ (00:00:04.88 elapsed) D CALL dbgen(sf 1); 100% ▕██████████████████████████████████████▏ (00:00:03.30 elapsed) D SELECT current_setting(threads); ┌────────────────────────────┐ │ current_setting(threads) │ │ int64 │ ├────────────────────────────┤ │ 12 │ └────────────────────────────┘ D copy lineitem to lineitem.csv(HEADER 0); D [1] 已停止 ./duckdb aaakylin-pc:~$ bg [1] ./duckdb 生成sf1数据集并复制lineitem 表到csv文件。然后测试用awk和duckdb分别汇总第五列包括csv文件和内存表。aaakylin-pc:~$ tail -2 lineitem.csv 6000000,32255,2256,1,5.00,5936.25,0.04,0.03,N,O,1996-11-02,1996-11-19,1996-12-01,TAKE BACK RETURN,MAIL,riously pe 6000000,96127,6128,2,28.00,31447.36,0.01,0.02,N,O,1996-09-22,1996-10-01,1996-10-21,NONE,AIR,pecial excuses nag evenly f [1] 已停止 ./duckdb aaakylin-pc:~$ time awk -F , {sum $5} END {print sum} lineitem.csv 153078795 real 0m3.354s user 0m2.825s sys 0m0.511s aaakylin-pc:~$ fg ./duckdb D .timer on D select sum(l_quantity)from lineitem; ┌──────────────────┐ │ sum(l_quantity) │ │ decimal(38,2) │ ├──────────────────┤ │ 153078795.00 │ │ (153.08 million) │ └──────────────────┘ Run Time (s): real 0.006 user 0.034716 sys 0.000045 D D select sum(column04)from lineitem.csv; ┌──────────────────┐ │ sum(column04) │ │ double │ ├──────────────────┤ │ 153078795.0 │ │ (153.08 million) │ └──────────────────┘ Run Time (s): real 0.653 user 5.333167 sys 0.343530结果一样性能差别明显。最后想起证书问题是否是系统时间不对引起的这个机器系统时间是1月26日而今天实际上是2月28日。