Question : I’ve set up a PostgreSQL FDW server with the following table, sharded by user_id over four servers: CREATE […]
Tag: postgresql-fdw
Create foreign key on foreign table in postgresql [duplicate]
Question : This question already has answers here: Foreign Key (references) constraint on PostgreSQL Foreign Data Wrapper? (2 answers) Closed […]
How often is Postgres parsing a foreign table based on file_fdw?
Question : I have a foreign table defined with file_fdw, which reads the data from a CSV file. Postgresql parses […]
Create shared user mapping in PostgreSQL foreign data wrapper server
Question : We are using a foreign data wrapper to query across databases on a single PostgreSQL RDS. The foreign […]
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”, […]
- 1
- 2