Re: [GENERAL] Indices and Foreign Tables

2014-04-04 Thread Kohler Manuel (ID SIS)
l time=1082.614..219083.326 rows=13839 loops=1) Filter: (parent_id IS NULL) Rows Removed by Filter: 35726596 Total runtime: 219438.925 ms (13 rows) Regards Manuel -- Kohler Manuel (ID SIS) Research Informatics, Scientific IT Services (ID ETHZ) Quantit

[GENERAL] Indices and Foreign Tables

2014-04-04 Thread Kohler Manuel (ID SIS)
that the indices are not used. I can also post the query plan if it helps. So am I doing something wrong here, or is this not possible that the indices are used by the fdw? Any hints are appreciated. Cheers Manuel -- Kohler Manuel (ID SIS) Research Informatics, Scientific IT Services (ID ETHZ

[GENERAL] JDBC driver for Postgres 9.3

2013-09-26 Thread Kohler Manuel
Hi, we are developing a Java based software with Postgres as a DB. Could someone tell me if there will be a JDBC driver for 9.3 out soon or is it safe and recommended to use the latest JDBC driver available? Currently we are using: PostgreSQL 9.2-1000 JDBC4 (build 1000) Kind regards Manuel -- Ma