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