hasura / hasura/graphql-engine

Additional information for cleaning up eventing data

Open
#7,826 0 comments 0 reactions 0 assignees View on GitHub
a/eventing/data-triggers c/docs k/bug
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version: N.A
CLI Version (for CLI related issue): N.A

### Environment

### What is the expected behaviour?
Report from a user when following https://hasura.io/docs/latest/graphql/core/event-triggers/clean-up.html

```
The job eventually completed, but it then started a very long AUTOVACUUM that created Transaction Logs that ate up all the database.

I ended up doing

truncate hdb_catalog.event_invocation_logs, hdb_catalog.event_log;

Which was much faster and prevented the AUTOVACUUM from running.

```

Contributor guide

Open the contributing guide

Research direction

Start with the event-trigger cleanup page at https://hasura.io/docs/latest/graphql/core/event-triggers/clean-up.html and review the reported behavior involving hdb_catalog.event_invocation_logs and hdb_catalog.event_log. Clarify the cleanup guidance and document the relevant database implications, with the page updated to address the report.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
databases, documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.