hacker news Hacker News
  1. new
  2. show
  3. ask
  4. jobs

Show HN: Vizier – A physical design advisor for DuckDB

5 points

by habedi0

20 hours ago

story

Hi,

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.

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:

Project's GitHub repo: https://github.com/CogitatorTech/vizier

Vizier documentation: https://cogitatortech.github.io/vizier/

loading...