Show HN: Vizier – DuckDB 的物理设计顾问
4 分•作者: habedi0•5 个月前
您好,
我为 DuckDB 开发了一个物理设计顾问的早期版本(名为 Vizier)。它可以分析一组查询(使用一组启发式方法),并建议更改数据库的物理设计/布局(例如,排序顺序、Parquet 布局、索引等),以使这些查询运行得更快。
Vizier 作为一个 DuckDB 扩展程序,用 Zig 语言实现,并支持 DuckDB 1.2.0 及更高版本。该项目还处于非常早期的阶段,但如果您有兴趣了解更多关于 Vizier 的信息或试用它,可以查看以下链接:
项目 GitHub 仓库:<a href="https://github.com/CogitatorTech/vizier" rel="nofollow">https://github.com/CogitatorTech/vizier</a>
Vizier 文档:<a href="https://cogitatortech.github.io/vizier/" rel="nofollow">https://cogitatortech.github.io/vizier/</a>
查看原文
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>