cockroachdb / cockroachdb/docs

Update batch delete guidance for performance improvements

Abierto
#12,165 2 comentarios 0 reacciones 1 asignado Reclamado por @ericharmeling Ver en GitHub
C-doc-improvement
Lenguaje dominante
HTML
Estrellas
212
Forks
476
Merge medio
40 min
PR fusionados (30 d)
3

Descripción

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

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.