gbrodman 6bd90e967b Add more hash indexes used during common flows (#2845) ...

I analyzed SQL statements run during the following flows and EXPLAIN
ANALYZEd each of them to figure out if there are any additional hash
indexes we could add that could be particularly helpful. Note: it's not
worth adding a hash index on the host_repo_id field in DomainHost
because so many rows (domains) use the same host.

- domain create
- domain delete
- domain info
- domain renew
- domain update
- host create
- host delete
- host update

I skipped the ones that use the read-only replica, as well as contact
flows (we're getting rid of them), and domain transfer/restore-related
flows as those are extremely infrequent.

2025-10-13 18:07:47 +00:00

..

main

Add more hash indexes used during common flows (#2845)

2025-10-13 18:07:47 +00:00

test

Update golden schema comparison in schema test (#2805)

2025-08-18 20:41:47 +00:00