Ability to push down JOIN, Sorts, UPDATEs and DELETEs to the remote database in postgres_fdw driver, and theoretically in other drivers. Also some generic operator/function pushdown.
Rows are read directly from BigQuery servers using the Arrow or Avro wire formats. The Storage API supports arbitrary pushdown of predicate filters. Connector version 0.8.0-beta and above support ...
You can also perform this exercise using a cable machine or resistance bands by standing on the band or anchoring it somewhere. A cable pushdown might also be called a rope pushdown and requires a ...