Show HN: Vizier – DuckDB 的物理设计顾问

4作者: habedi05 个月前
您好, 我为 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&#x27;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&#x2F;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&#x27;re interested in learning more about Vizier or trying it out, you can check out the links below:<p>Project&#x27;s GitHub repo: <a href="https:&#x2F;&#x2F;github.com&#x2F;CogitatorTech&#x2F;vizier" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;CogitatorTech&#x2F;vizier</a><p>Vizier documentation: <a href="https:&#x2F;&#x2F;cogitatortech.github.io&#x2F;vizier&#x2F;" rel="nofollow">https:&#x2F;&#x2F;cogitatortech.github.io&#x2F;vizier&#x2F;</a>