votingworks / arlo

GNU Affero General Public License v3.0
141 stars 25 forks source link

Ensure that CVR deletion uses SQL index instead of a seq scan #1902

Open arsalansufi opened 6 months ago

arsalansufi commented 6 months ago

While we've implemented some bandaid fixes (https://github.com/votingworks/arlo/pull/1890 and https://github.com/votingworks/arlo/pull/1892) and should be able to get through the current audit season just fine, we should still get to the bottom of this (sometimes) slow query.

Full context here: https://votingworks.slack.com/archives/CKCVA0F9S/p1708991197400939