Skip to content

Improve various Geo FDW queries that need aggregate pushdown to be fast

Nick Thomas requested to merge (removed):4491-geo-fdw-optimise-queries into master

What does this MR do?

Geo needs to perform lookups against data in two separate databases. This MR improves a number of queries that are currently slow when FDW is enabled in pg 9.6

Are there points in the code the reviewer needs to double check?

Why was this MR needed?

Aggregate pushdown is only available in postgresql 10.0 or greater. This greatly slows down a number of queries. Without fast FDW-using queries, Geo is not GitLab.com-scalable.

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

What are the relevant issue numbers?

Closes #4491 (closed)

Edited by Nick Thomas

Merge request reports

Loading