cockroachdb / cockroachdb/docs

Update batch delete guidance for performance improvements

Open
#12,165 2 comments 0 reactions 1 assignee Claimed by @ericharmeling View on GitHub
C-doc-improvement
Dominant language
HTML
Stars
212
Forks
476
Avg merge
40m
Merged PRs (30d)
3

Description

Eric Harmeling (ericharmeling) commented:

this example will cause performance issues in production based on my testing of what [this webpage](https://www.cockroachlabs.com/docs/stable/bulk-delete-data.html) recommended, and to avoid that, one should do

```
BEGIN
SELECT FROM rides AS OF SYSTEM TIME -30s WHERE
ROLLBACK

BEGIN LOW PRIORITY TRANSACTION; DELETE FROM rides WHERE PK IN (...); COMMIT
```

_Originally posted by @otan in https://github.com/cockroachdb/docs/pull/12114#discussion_r741472484_

Jira Issue: DOC-1137

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.