The current indices have been inappropriate since ArchiveRework in 2006-7, but the planner still makes bad choices. adding an index on packageupload(archive, distroseries, status, id) brings the query down to <1ms.
The current indices have been inappropriate since ArchiveRework in 2006-7, but the planner still makes bad choices. adding an index on packageupload( archive, distroseries, status, id) brings the query down to <1ms.