citusdata / citusdata/citus

Enable long-running operations to run in the background

Open
#3,937 0 comments 0 reactions 0 assignees View on GitHub
feature
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.