Geo - Improve query to determine LFS objects to sync when selective sync is enabled
requested to merge 10286-geo-sql-statement-times-out-whilst-determining-lfs-objects-to-sync into master
What does this MR do?
Remove an unnecessary join with projects table while determining LFS objects to sync when selective sync is enabled.
Database checklist
-
Conforms to the database guides -
Included data that shows the performance improvement, preferably in the form of a benchmark -
Included the output of EXPLAIN (ANALYZE, BUFFERS)of the relevant queries
Related issues
Edited by Douglas Barbosa Alexandre