Re: [GENERAL] UDF calls and FDW

2014-04-04 Thread Tom Lane
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

[GENERAL] UDF calls and FDW

2014-04-04 Thread Emmanuel Medernach
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