Emmanuel Medernach writes:
> So the problem is that is calls the UDF on the FDW node (Foreign
> Scan on master_object_000 + Filter) and not on the remote server.
Right.
>- How to call the UDF on the remote server ?
postgres_fdw intentionally refuses to do this, because it has no way
to kno
Hello,
I am using FDW to transparently access a remote Postgres database
containing a table indexed with the Q3C library.
On the remote server :
postgres=# SELECT * FROM object_000 WHERE q3c_radial_query(ra_PS, decl_PS,
1.3, 3.4, .2) ;
...
(2416 rows)
Time: 130.300 ms
But on the FDW