Geo: Make foreign data wrapper a hard requirement
Problem to solve
Foreign Data Wrapper (FDW) is a feature built-in in PostgreSQL. It allows data to be queried from different data sources. In Geo, it’s used to query data from different PostgreSQL instances (source: documentation). It also improves the performance of some queries, especially for Finders, which look up projects or attachments in the tracking database and main database. FDW allows finders to perform
JOIN operations across the tracking and the main database (source: documentation).
Currently, FDW is only a soft requirement for the use of Geo; however, we believe that the performance improvements and implications for selective sync warrant making FDW a hard requirement. This will raise the minimum PostgreSQL version to 9.6.
This is also a prerequisite to improving the performance of selective sync queries for Geo: #7109 (comment 136712102)
- Devon (DevOps Engineer)
- Based on the test results from #10965 (closed) we can make FDW a hard requirement on a major version bump.
- Finder queries requiring FDW: https://gitlab.com/gitlab-org/gitlab-ee/tree/master/ee/app/finders/geo
Make FDW a hard requirement for using Geo starting with version 12.0.