Vizier – A physical design advisor for DuckDB

Name: Vizier – A physical design advisor for DuckDB
Availability: InStock
Author: habedi0

by habedi0·Mar 26, 2026·6 points·0 comments

Visit Project View on HN

AI Analysis

●●SolidNiche GemBig Brain

Finally a tuning advisor for DuckDB when pg_qualstats exists for PostgreSQL.

Strengths

•Fills genuine gap — no equivalent to SQL Server's Database Engine Tuning Advisor for DuckDB.
•Before/after benchmarking and rollback support for applied recommendations.
•Zig extension means low overhead and cross-platform support out of the box.

Weaknesses

•Early stage with expected breaking changes and limitations documented.
•Niche audience limits adoption — only matters if you're already using DuckDB heavily.

Post Description

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/