citusdata / citusdata/citus

If the user runs a query with a filter clause like 'timestamp > now() - 1 day', we don't apply partition pruning.

Open
#64 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

If the user runs a query with a filter clause like 'timestamp > now() - 1 day', we don't apply partition pruning.

Contributor guide

Open the contributing guide

Research direction

No file, test, or entry point is named in the issue. Start by locating the partition-pruning path for filters involving now() and determine why the example time expression is skipped; done means the query applies partition pruning for that filter.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.