[GENERAL] Performance issue with postgres_fdw

2014-08-29 Thread Emmanuel Medernach
ns when dealing with tables on the same pool ? And to automatically export the query directly in that case ? What may I do for now ? Thanks for your help and best regards, -- Emmanuel Medernach -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[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

Re: [GENERAL] postgres-fdw questions

2014-01-27 Thread Emmanuel Medernach
On 01/24/2014 04:58 PM, Jim Mlodgenski wrote: On Fri, Jan 24, 2014 at 4:20 AM, Emmanuel Medernach mailto:meder...@clermont.in2p3.fr>> wrote: Hello, I'm currently testing postgres_fdw feature on PostgreSQL 9.3.2 and I have some questions: - What are the li

[GENERAL] postgres-fdw questions

2014-01-24 Thread Emmanuel Medernach
Hello, I'm currently testing postgres_fdw feature on PostgreSQL 9.3.2 and I have some questions: - What are the limits to the number of foreign tables ? - What is the current status about foreign joins push-down ? Thanks in advance, -- <> -- Sent via pgsql-general mailing list (pgsql-gener