Geo: Continue to make registry table SSOT for LFS objects
The following discussion from !20002 (merged) should be addressed:
-
@dbalexandre started a discussion: (+2 comments) Should we change this method to not rely on FDW too?
LfsObjectRegistryFinder
has a bunch of methods that still use FDW. If the feature flag :geo_lfs_registry_ssot_sync
is enabled, let's make more things treat the registry table as SSOT (don't do a cross-database join, instead just query the registry table).
Caveats
- This issue depends on #204797 (closed) since we must ensure registries are removed if they should not be synced.
- We might want to leave counts alone for now, since we don't have create events. If we don't have create events, then anything treating the registry as SSOT can be up to 2 minutes out-of-date for new items.
Edited by Michael Kozono