mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
a231b5aef5
Fixes #12780 Adds indexes to the `tailnet_tunnels` table to speed up `GetTailnetTunnelPeerIDs` and `GetTailnetTunnelPeerBindings` queries, which match on `src_id` and `dst_id`.
4 lines
257 B
SQL
4 lines
257 B
SQL
-- Since src_id and dst_id are UUIDs, we only ever compare them with equality, so hash is better
|
|
CREATE INDEX idx_tailnet_tunnels_src_id ON tailnet_tunnels USING hash (src_id);
|
|
CREATE INDEX idx_tailnet_tunnels_dst_id ON tailnet_tunnels USING hash (dst_id);
|