Connection timeouts while long running CREATE INDEX CONCURRENTLY
Open
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
A user was running running several "CREATE INDEX CONCURRENTLY" commands for few hours. During that time cpu usage on workers was almost 100%. When they were running other SELECT queries from the coordinator during that time, they often saw worker connection timeout errors.
They were using Citus 9.0 with adaptive executor.
Contributor guide
Assessment
This issue has not been assessed yet.