sql performance Show more
UPDATE repos SET watching = false
170+ minutes before I stopped it.
UPDATE repos SET watching = false WHERE watching = true
Under 10 minutes.
(Yes, the table has been vacuumed recently. There's an index which includes `watching` that I expected would be used in both cases, but apparently not in the former. It's non-nullable, so the queries are equivalent.)
This is a personal Mastodon instance.