Postgresql Foreign Data Wrappers, enable the ability to access remote data stores from postgresql.
1
vote
0answers
20 views
Postgresql FDW oracle out of memory
I have a linux box with centos 6.7 and postgres 9.3.9.
I have a foreign data wrapper throught an oracle 11.2 box and a jdbc driver.
It's working fine since several months, but yesterday I had to ...
0
votes
0answers
35 views
Foreign table not using index
I have a table on database temp_db named external_objects and an index on the field id, which is an MongoDB id (like 5458d717cd07870859000003). When I explain this select at this database, I got this
...
0
votes
0answers
23 views
doing a insert while selecting an specific user
I'm importing and legacy database to a new database, and changing data format. In this legacy database, I have data as following:
Interaction
id: 5458d717cd07870859000004
user_id: ...
2
votes
2answers
195 views
manual execution of specific remote query with postgresql_fdw
In 9.4b2, postgresql_fdw doesn't know how to "push down" aggregate queries on remote tables, e.g.
> explain verbose select max(col1) from remote_tables.table1;
...
