Postgres FDW: Pushdown is a negotiation

The article explains that PostgreSQL Foreign Data Wrappers (FDW) use a pushdown negotiation process where the foreign server indicates which SQL operations it can handle, rather than assuming full capability. This allows efficient query delegation by pushing down filtering, sorting, and joins only when the remote source supports them.