Question : We are using a foreign data wrapper to query across databases on a single PostgreSQL RDS. The foreign […]
Tag: postgresql-fdw
ORDER BY too slow in Foreign Table using postgres_fdw
Question : PostgreSQL v9.6, postgres_fdw Foreign table CREATE FOREIGN TABLE user_info ( id bigint , info jsonb ) SERVER server_test_fdw […]
how to add a query to postgres and have it show up as a table
Question : I’m not sure what technology I need because I’m not a DBA, but I’m sure there’s a good […]
How do I set the option use_remote_estimate?
Question : Where do I set the “Cost Estimation Options” for postgres_fdw. Specifically I want to add use_remote_estimate. test=# SET […]
Copy large object field into remote PostgreSQL DB [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
manual execution of specific remote query with postgresql_fdw
Question : In 9.4b2, postgresql_fdw doesn’t know how to “push down” aggregate queries on remote tables, e.g. > explain verbose […]
postgres_fdw performance is slow
Question : The following query on a foreign takes about 5 seconds to execute on 3.2 million rows: SELECT x.”IncidentTypeCode”, […]
Why does PostgreSQL FDW talk to multiple backend servers for this point query?
Question : I’ve set up a PostgreSQL FDW server with the following table, sharded by user_id over four servers: CREATE […]
naming a column differently then its original one in foreign data wrapper of PostgreSQL
Question : I have two databases. In each database I have an employee table which differ from each other in […]
FDW use in postgres
Question : I need to create a sequence and need to use the sequence for auto increment id for more […]
- 1
- 2