duckdb / duckdb/pg_duckdb

Don't plan twice for prepared statements

Open
#229 0 comments 0 reactions 0 assignees View on GitHub
performance
Dominant language
C++
Stars
3.2k
Forks
204
PR merge metrics
No merged PRs in 30d

Description

In #147 we added support for prepared statements, but that was done planning the query twice in DuckDB, once during planning to get the the column types of the result and once during execution. While this works, it's clearly suboptimal performance wise, and it's something we should change eventually.

Contributor guide

Open the contributing guide

Research direction

Start by reading issue #147 to understand the existing prepared-statement support, then trace how DuckDB planning is used first to obtain result column types and again during execution. Done means prepared statements no longer plan the query twice while preserving the existing behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, postgres
Domain
backend, databases
Issue type
Refactor
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.