argoproj / argoproj/argo-workflows
argo_archived_workflows table partitions
Open
area/workflow-archive
- Dominant language
- Go
- Stars
- 17k
- Forks
- 3.7k
- Avg merge
- 1d 20h
- Merged PRs (30d)
- 138
Description
argo_archived_workflows can get quite large, to improve selects i suggest having a new default column at date level (dd-mm-yyyy) and partition on it
Contributor guide
Research direction
Locate the schema or migration that defines argo_archived_workflows and inspect the queries that read archived workflows. Determine how a date-level default column and partitioning should be represented there; done means the table is partitioned by that value and the relevant selects continue to work.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100