cockroachdb / cockroachdb/cockroach
changefeedccl: better performance for CDC queries
Open
A-cdc
C-enhancement
T-cdc
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
A customer is running the following CDC Query and seeing significant performance impact (increased CPU usage and decreased throughput). We should investigate ways to improve the performance of CDC Queries
Their query:
CREATE CHANGEFEED ... AS SELECT *, event_op() AS __event__ FROM [table] WHERE _source = 'east' and (event_op() = 'insert' OR event_op() = 'update' OR event_op() = 'delete');
Jira issue: CRDB-36650
Epic CRDB-37338
Contributor guide
Assessment
This issue has not been assessed yet.