Partitioning issues: Efficient way to query for assigned issues
This is a follow-up to the spike on partitioning in #201871 (closed) and the discussion in gitlab-com/www-gitlab-com!43179 (comment 306513346).
This is the user's dashboard with assigned issues: https://gitlab.com/dashboard/issues?assignee_username=$user
For this type of search, we found that query plans get a lot worse with partitioning. Here's an example with details: gitlab-org/database-team/team-tasks$1954580
This issue is about discussing the problem of queries that don't have a partitioning key and how we solve this.