citusdata / citusdata/citus

Create Indexes Before Dropping Tables in Alter Table UDFs

Open
#4,690 1 comment 0 reactions 0 assignees View on GitHub
performance
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

The `postLoadCommands` in the `ConvertTable` function can take a long time for large tables because indexes are created there. Moving them to before dropping the old table could prevent blocking reads.

The problem is before dropping the old table the old indexes will still be there, so there might need to be some renaming for the indexes.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.