展示 HN：Vizier – DuckDB 的物理设计顾问
你好，
我为 DuckDB 制作了一个早期版本的物理设计顾问（称为 Vizier）。它可以分析一组查询（使用一套启发式方法），并推荐对数据库的物理设计/布局进行更改（例如，排序顺序、Parquet 布局、索引等），以使这些查询运行得更快。
Vizier 是作为 DuckDB 的一个扩展实现的，使用 Zig 编写，支持 DuckDB 版本 1.2.0 及更高版本。该项目仍处于早期阶段，但如果你有兴趣了解更多关于 Vizier 的信息或进行试用，可以查看以下链接：
项目的 GitHub 仓库： [https://github.com/CogitatorTech/vizier](https://github.com/CogitatorTech/vizier)
Vizier 文档： [https://cogitatortech.github.io/vizier/](https://cogitatortech.github.io/vizier/)
查看原文
Hi,<p>I've made an early version of a physical design advisor (called Vizier) for DuckDB. It can analyze a collection of queries (using a set of heuristics) and recommend changes to the physical design/layout of the database (for example, sort orders, Parquet layouts, indexes, etc.), in order to make those queries run faster.<p>Vizier is implemented as a DuckDB extension in Zig and supports DuckDB version 1.2.0 and newer. The project is very early-stage, but if you're interested in learning more about Vizier or trying it out, you can check out the links below:<p>Project's GitHub repo: <a href="https://github.com/CogitatorTech/vizier" rel="nofollow">https://github.com/CogitatorTech/vizier</a><p>Vizier documentation: <a href="https://cogitatortech.github.io/vizier/" rel="nofollow">https://cogitatortech.github.io/vizier/</a>