Skip to content

Add index to tailnet_tunnels table #12780

Closed
@stirby

Description

@stirby

A customer's deployment recently shutdown due to repeated hits of the tailnet_tunnels table. Adding indexes to this table will reduce the cost of queries and potentially mitigate future crashes when the DB is overburdened.

See full context below:
https://github.com/coder/customers/issues/518

cc: @kylecarbs @spikecurtis

Metadata

Metadata

Assignees

Labels

customer-reportedBugs reported by enterprise customers. Only humans may set this.networkingArea: networking

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions