Enable long-running operations to run in the background
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
It would be useful to be able to run potentially long-running operations such as create_distributed_table, CREATE INDEX, and rebalance_table_shards in the background such that the user does not need to keep a terminal window open. The status/progress and result of the command need to be made visible in a table.
This functionality is somewhat similar to pg_cron, but pg_cron only supports periodically running a command.
Contributor guide
Research direction
Start by examining how create_distributed_table, CREATE INDEX, and rebalance_table_shards currently run, then compare the requested behavior with pg_cron. Done means long-running operations can continue after the terminal closes, with their status, progress, and result visible in a table.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100