[Housekeeping] Remove unused index on execution error code

[katrogan]

Describe the issue

See

flyte/flyteadmin/pkg/repositories/models/execution.go

Line 56 in 38883c7

ErrorKind *string `gorm:"index"`

indicies slow down writes and come with an I/O overhead. We should clean up any that are unused

What if we do not do this?

Impact on perf for writes to executions table in flyteadmin

Related component(s)

flyteadmin

Are you sure this issue hasn't been raised already?

• Yes

Have you read the Code of Conduct?

• Yes

[katrogan]

cc @eapolinario

[runllm]

The issue you described pertains to removing an unused index on the execution error code in the execution model to improve write performance. According to the execution model, the ErrorCode field is indexed, which can indeed slow down write operations due to the additional I/O overhead.

Would you like more detail on how to identify and remove this index, or any other specific aspect of this issue?

Sources:

• execution model

---

This is an AI-generated response and your feedback is appreciated! Please leave a 👍 if this is helpful and 👎 if it is not.

Mention @RunLLM to ask follow-up questions. See runllm.com for more!